Re: SQL Statement
From: Peter Nilsson <airia_at_acay.com.au>
Date: Tue, 24 Feb 2009 14:12:13 -0800 (PST)
Message-ID: <77688a2e-5bc2-49f0-bde4-ea7ee30e9797_at_g38g2000yqd.googlegroups.com>
mrdjmag..._at_aol.com wrote:
> 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.......
Why? What have you got against UNION ALL?
Date: Tue, 24 Feb 2009 14:12:13 -0800 (PST)
Message-ID: <77688a2e-5bc2-49f0-bde4-ea7ee30e9797_at_g38g2000yqd.googlegroups.com>
mrdjmag..._at_aol.com wrote:
> 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.......
Why? What have you got against UNION ALL?
-- PeterReceived on Tue Feb 24 2009 - 16:12:13 CST