Can these two SELECT statements be mergerd into one with the ORDER BY happening first?
SELECT [controlNum], [transDate] FROM [EDI_Control].[dbo].[InterchangeControl] WHERE controlNum > 0 ORDER BY [transDate];
SELECT [controlNum], [transDate] FROM [EDI_Control].[dbo].[InterchangeControl]...