Viewing post 1 (of 1 total)
Use Dynamic query...
DECLARE @auto varchar(20)
DECLARE @industrial varchar(20),@SQL varchar(500)
SET @auto='MD'','+'''RD'
SET @industrial='ID'','+'''IW'
Set @sql='select * from Customer where CustomerClass in ('''+@ind+''')'
Exec (@SQL)
October 9, 2009 at 3:51 am
#1063952