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 |
Clages1
Yak Posting Veteran
69 Posts |
Posted - 2008-04-10 : 15:43:02
|
HiIf i do thisselect * from tablex where colX in ('A','B') works finebut i would like to do thisdeclare @filterset @filter = ' 'A', 'B' 'select * from tablex where colX in (@filter) How can i do this?TksClages |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-04-10 : 15:49:33
|
http://www.sommarskog.se/dynamic_sql.html E 12°55'05.25"N 56°04'39.16" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-04-11 : 05:45:08
|
http://www.sommarskog.se/arrays-in-sql.htmlMadhivananFailing to plan is Planning to fail |
|
|
|
|
|