title: SQL Query and Array with IN function
body: <p>I have an array that I need to match with another dimension (VARCHAR). I need a User_ID to match against a list of the below Test_IDs, however the Test ID will always vary so I can't hard code in the variables.</p>
  <p>Example array with the dimension</p>
  <pre><code>TestID[14782273,10904275,1454477270,16526331,1323009,1450722,529479190,1195598]
  </code></pre>
  <hr />
  <pre><code>SUM(CASE
      WHEN User_ID IN TEST_ID
             THEN 1
          ELSE
          0
        END)
        AS Complete_Items
  </code></pre>