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 |
|
turbo
Starting Member
19 Posts |
 Posted - 2011-01-07 : 08:45:51
|
| i have a SP where i insert data into a table_one,declare @ip nvarchar(111) = '1,2,3'insert into @table_one (id , col1, col2)select id , col1, col2 from test_table where id in (@ip)the above doesnt work . I came to know , i should pass the above @ip param in a dynamic query ..Is ter any other means of passing the param other than in a dynamic query ??? |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2011-01-07 : 09:04:39
|
| What you can do is pass @ip in as-is, and then use fnParseValues (found on this site) that you can then join to.JimEveryday I learn something that somebody else already knew |
 |
|
|
|
|
|
Need Help in Insertion into a table