title: how to pass variables this in dynamic query in sql
body: <p>i using the dynamic query to pass the variables</p>
  
  <pre><code>select a.TableName, COUNT(a.columnvalue) as '+'count'+' from Settings a
  where a.ColumnValue in ('+ @columnvalue +') and a.Value in (' + @value +')
  
  the @columnvalues = 'a','b','c'
  @value ='comm(,)','con(:)'
  </code></pre>
  
  <p>how to pass this in dynamic query</p>
  
  <p>any idea???</p>