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?Example:I want to populate a drop down list with SELECT EmpID ...

I have a SELECT statement, it is calculating the same DateDiff about 5 times.I'm using some CASE WHEN stuff and the result of DateDiff in days is how I determine what part of the case it goes with ...