SQL Statement

From: <mrdjmagnet_at_aol.com>
Date: Tue, 24 Feb 2009 13:10:11 -0800 (PST)
Message-ID: <22caad95-268b-4acf-8ea6-4fa68b72488e_at_t13g2000yqc.googlegroups.com>


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

Original text of this message