title: Combine string_split column results in table SQL
body: <p>I'm trying to create a stored procedure for updating a table in a batch. I want to take parameters in as a <code>nvarchar</code> and call <code>string_split</code> on them.</p>
  
  <pre><code>@ParamList1 NVARCHAR(max) = '1,2,3,4,5'
  @ParamList2 NVARCHAR(max) = 'a,b,c,d,e'
  </code></pre>
  
  <p>I want to get a temporary table like </p>
  
  <pre><code>Param1  Param2
  1       a
  2       b
  3       c
  ...
  </code></pre>
  
  <p>How would I do this?</p>