Re: SQL Statement
From: <mrdjmagnet_at_aol.com>
Date: Tue, 24 Feb 2009 13:28:11 -0800 (PST)
Message-ID: <f6b47fe3-b168-4515-8b09-13780a31e91a_at_j1g2000yqi.googlegroups.com>
On Feb 24, 3:20�pm, ddf <orat..._at_msn.com> wrote:
> 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
Date: Tue, 24 Feb 2009 13:28:11 -0800 (PST)
Message-ID: <f6b47fe3-b168-4515-8b09-13780a31e91a_at_j1g2000yqi.googlegroups.com>
On Feb 24, 3:20�pm, ddf <orat..._at_msn.com> wrote:
> 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
The other way, is to possibly run a query that would return only the 4 employee ID's, excluding the one passed in, and then create the dynamic query string using an IN clause, with the 4 from the previous query plus the one passed in.....
That would work. Received on Tue Feb 24 2009 - 15:28:11 CST