Re: SQL Statement
From: ddf <oratune_at_msn.com>
Date: Tue, 24 Feb 2009 13:20:13 -0800 (PST)
Message-ID: <1363423f-36be-4194-a0bb-f5e04d067c58_at_u18g2000vbb.googlegroups.com>
On Feb 24, 3:10 pm, mrdjmag..._at_aol.com 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
Date: Tue, 24 Feb 2009 13:20:13 -0800 (PST)
Message-ID: <1363423f-36be-4194-a0bb-f5e04d067c58_at_u18g2000vbb.googlegroups.com>
On Feb 24, 3:10 pm, mrdjmag..._at_aol.com 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