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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-25 : 16:01:21
|
Magnus writes "I would like to know how you build a dynamic stored procedure that searches a table differently depending on which parameters are set.
You probably already have understood the question but to be on the safe side I'll explain some more:
I have a table that contains data in multiple columns (ie 6 columns) and I want to create a stored procedure that has one optional parameter for each column so that I can add a search criteria to either one, two or more columns and get the result that I want.
Sounds pretty easy but it was harder then I thought...
If I haven't explained myself enough, please write me a few lines and I'll try to explain better. Please mail a private mail to me if (more likely "when") you have solved my question.
/Cheers
Magnus Eriksson
magnus.eriksson@capgemini.se" |
|
|
|
|
|
dynamic search in as a stored procedure