fixthebug2003
Programmer
Hi,
I need a SQL which looks like this:
SELECT X,Y,Z FROM TABLE1 WHERE
TABLE1.NAME in (@variable1)
Now, this @variable1 should have values like this
'name1','name2','name3' that needs to be built (can have hard-coded values too)
so that the SQL query can execute...But how can I build this @variable1 in SQL Server 2000
thanks
Fixthebug2003
I need a SQL which looks like this:
SELECT X,Y,Z FROM TABLE1 WHERE
TABLE1.NAME in (@variable1)
Now, this @variable1 should have values like this
'name1','name2','name3' that needs to be built (can have hard-coded values too)
so that the SQL query can execute...But how can I build this @variable1 in SQL Server 2000
thanks
Fixthebug2003