IF EXISTS Snippets

No Data to Report

IF EXISTS (SELECT datafeed_record FROM [dbo].[sourcetable])
    SELECT datafeed_record AS record FROM [dbo].[sourcetable]
ELSE
    SELECT '"' + 'No Data to Report.' + '"' 'record'
;