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-11-13 : 08:14:30
|
| joe writes "I have a question for you. I have a comma delimited string that I wish to a SQL Server 7.0 Stored Procedure, ex. 'a,b,c,d'. I wish to then use this within the where clause of a CURSOR like, declare cur_name cursor for select * from table where idno not in (@stringpassed). I have not been able to get this to work with any methods that I have tried. Can this be done?" |
|
|
|
|
|
How do i use NOT IN within CURSOR with a delimited string passed to stored proc.