Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Dynamic Stored Procedures

Author  Topic 

GrindCrusher
Starting Member

7 Posts

Posted - 2003-01-14 : 13:20:28
Sorry if this has been posted... I havent seen it yet...Anyways

Im looking to create a dynamic stored procedure to query a table dependent on (4) search fields. Now the required results are if 1 search field is chosen then only search by that field, if 2,3 or 4 fields are selected then search by all those seleceted fields respectly.
Thanx for your help......

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2003-01-14 : 14:08:53
read Implementing a Dynamic WHERE Clause

Jay White
{0}
Go to Top of Page

GrindCrusher
Starting Member

7 Posts

Posted - 2003-01-14 : 14:47:59
Hey thanks I did find the solution.......

Go to Top of Page
   

- Advertisement -