I have a table that contains 6 fields
(JobGUID, FunctionName,InFileName,InFileSize,OutFileName,OutFileSize)
CheckFile
UnZipFile
CheckFile
InFileName
InFileSize
UnZipFile
OutFileName
OutFileSize
SELECT CheckFile.InFileName, CheckFile.InFileSize,
UnZipFile.OutFileName, UnZipFile.OutFileSize,
CheckFile.InFileSize - UnZipFile.OutFileSize as 'FileSizeDifference'
FROM [MY_DATABASE].[dbo].[MY_TABLE] CheckFile
JOIN [MY_DATABASE].[dbo].[MY_TABLE] UnZipFile ON CheckFile.InFileName = UnzipFile.OutFileName
WHERE CheckFile.JobGUID = 'Some GUID #'
and CheckFile.FunctionName = 'CheckFile'
and UnZipFile.FunctionName = 'UnZipFile'
and CheckFile.InFileName like '%.txt'