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 |
|
burbakei
Yak Posting Veteran
80 Posts |
 Posted - 2002-11-12 : 12:38:53
|
| I have read an article in sqlteam.com site that we can use COALESCE in whereclause instead of using dynamic EXEC.my problem is that i have IN in where clause. i want to write something likSELECT *FROM MyTableWHERE MyCol IN (...)and i dont know what i do want for search for in IN clause in advance.can anybody help me how can i do it without EXEC? |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
|
|
|
|
|
Implementing a Dynamic WHERE Clause
