how to pass variables this in dynamic query
- by Ranjana
i using the dynamic query to pass the variables
select a.TableName, COUNT(a.columnvalue) as '+'count'+' from Settings.ColumnMapping a
where a.ColumnValue in ('+ @columnvalue +') and a.Value in (' + @value +')
the @columnvalues = 'a','b','c'
@value ='comm(,)','con(:)'
how to pass this in dynamic query
any idea???