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 |
|
Ciupaz
Posting Yak Master
232 Posts |
 Posted - 2012-03-05 : 03:35:03
|
| Hello,I need to write an Update in a stored procedure that has 2 parameters, an ID int value, and a string of comma separated values of ID's, like these:create stored procedure dbo.InsertAttachedDocumentatation@IDDoc int@IDListTypeDoc nvarchar(50)as insert dbo.IssueDocAttached(IDIssue, IDTypeDoc)values......and I'd like to call in this way:EXEC dbo.InsertAttachedDocumentatation 1, '2,5,7,9'to obtain1 - 21 - 51 - 71 - 9in my dbo.IssueDocAttached table.How can I solve this problem?Luigi |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
|
|
Ciupaz
Posting Yak Master
232 Posts |
Posted - 2012-03-05 : 05:50:36
|
| Thank you Senthil. |
 |
|
|
|
|
|
Insert with a sort of foreach statement