Re: SQL Statement

From: ddf <>
Date: Tue, 24 Feb 2009 13:20:13 -0800 (PST)
Message-ID: <>

On Feb 24, 3:10 pm, wrote:
> Hello,
> 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

Provide an example of the output you want to see, as well as the table definition and some sample data.

David Fitzjarrell Received on Tue Feb 24 2009 - 15:20:13 CST

Original text of this message