gjshah7254
6/11/2015 - 3:51 AM

SQL query to check IF results exists ELSE

SQL query to check IF results exists ELSE

new_gist_file_0.sql
content_copyfile_download
IF ((SELECT COUNT([ID]) FROM [SMS_Entries] WHERE [Field] = 141) > 0) 
    SELECT * FROM [SMS_Entries]
ELSE
    SELECT TOP 1 'NA' FROM [SMS_Entries]