title: SQL batch query processing (SQL query input array)
body: <p>I have SQL query like </p>
  
  <pre><code>SELECT *, dbo.func(@param1, a.point) as fValue 
  FROM dbo.table AS a 
  WHERE dbo.func(@param1, a.point) &lt; @param2
  </code></pre>
  
  <p>When this query is executed only once, everything is fine, but when I have array of input @param1 values let's say, over 100 values, executing and fetching results for every value take s a lot of time.</p>
  
  <p>Is it possible to pass array of @param1 into the query somehow, and receive dataset for all the input values, instead of executing it for each value?</p>
  
  <p>function func() doing some math on 2 values. @param1 and a.point are type of double. and, yeah, a.point - is not an ID, and it is not a unique value.  </p>
  
  <p>I know, it should be really easy, but it looks like I'm missing something.</p>