Home Forums SQL Server 7,2000 T-SQL Stored procedure using dynamic query RE: Stored procedure using dynamic query
tkbr0wn
Ten Centuries
Points: 1092
More actions
June 3, 2003 at 11:39 am
#459590
I have the exec commented out in my example. It produces a query that has an accurate where clause without all the other extraneous stuff. All you have to do to get it to run is uncomment out the exec and change it to match your structure.