"Ray" <Ray@discussions.microsoft.com> wrote in message
news:487EA85C-3809-48D5-ADCD-7021B8FC4AFF@microsoft.com...
> I have an application that allows the user to select various fields to
> display and/or use as the search criteria to locate a record and I then
build
> the entire SQL clause in code and execute the SQL clause from code. The
> records returned are actually a UNION of 4 different VIEWS.
>
> Is it possible to pass in the SELECT and WHERE clauses as the parameters
to
> the stored procedure like;
>
> SELECT @Select FROM View1 WHERE @Where
> UNION
> SELECT @Select FROM View2 WHERE @Where
> ...
>
> I am using SQL Server 2000.
>
> Thanks,

"Ray" <Ray@discussions.microsoft.com> wrote in message
news:487EA85C-3809-48D5-ADCD-7021B8FC4AFF@microsoft.com...
>I have an application that allows the user to select various fields to
> display and/or use as the search criteria to locate a record and I then
> build
> the entire SQL clause in code and execute the SQL clause from code. The
> records returned are actually a UNION of 4 different VIEWS.
>
> Is it possible to pass in the SELECT and WHERE clauses as the parameters
> to
> the stored procedure like;
>
> SELECT @Select FROM View1 WHERE @Where
> UNION
> SELECT @Select FROM View2 WHERE @Where
> ...
>
> I am using SQL Server 2000.
>
> Thanks,

"Raymond D'Anjou" wrote:

> Before you implement this... read on.
> http://www.sommarskog.se/
> especially the chapters "The curse and blessings of dynamic SQL" and
> "Dynamic search conditions".
>
> "Ray" <Ray@discussions.microsoft.com> wrote in message
> news:487EA85C-3809-48D5-ADCD-7021B8FC4AFF@microsoft.com...
> >I have an application that allows the user to select various fields to
> > display and/or use as the search criteria to locate a record and I then
> > build
> > the entire SQL clause in code and execute the SQL clause from code. The
> > records returned are actually a UNION of 4 different VIEWS.
> >
> > Is it possible to pass in the SELECT and WHERE clauses as the parameters
> > to
> > the stored procedure like;
> >
> > SELECT @Select FROM View1 WHERE @Where
> > UNION
> > SELECT @Select FROM View2 WHERE @Where
> > ...
> >
> > I am using SQL Server 2000.
> >
> > Thanks,
>
>