Ars Technica

TSQL: Possible to add a single hard coded row to a SELECT statement that returns rows

Maybe this is a strange question, but is there a way to add a single row (or several) to the return set of a SELECT statement?
Ars Technica

TSQL: IF EXIST statement as conditional check

Ok, I'm thinking there must be a better way to do this. I want to see if today's date exists in a table, if it does NOT then I want to do "stuff". Code: IF NOT EXISTS (SELECT COUNT(ExecutionDate) FROM ...