Date: Tue, 24 Feb 2009 13:10:11 -0800 (PST)
Can you have a select statement that returns a literal AND normal query results without a UNION?
Say I have a parameter, like and employee ID, passed to a procedure. I want to run a query which returns the top 4 records in the result set PLUS the values from the employee ID passed in.......So, 5 records total.
The query is long, so I'm hoping to do it without a UNION.......
Much Thanks Received on Tue Feb 24 2009 - 15:10:11 CST