title: Convert JSON value in SQL table to multiple columns
body: <p>One of my SQL table has two columns in the below format. Column &quot;Parameters&quot; in JSON Format</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Value</th>
  <th>Parameters</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>999-99-9999</td>
  <td>{&quot;A&quot;:null,&quot;B&quot;:&quot;dfsnl&quot;,&quot;C&quot;:&quot;dfdfs&quot;,&quot;D&quot;:&quot;dsfdfs&quot;,&quot;E&quot;:&quot;&quot;,&quot;F&quot;:&quot;dfssdfsdfdsf&quot;,               &quot;G&quot;:null,&quot;H&quot;:&quot;dfdsf,dfssfddfsdsffds&quot;,&quot;I&quot;:&quot;73834874378&quot;,&quot;J&quot;:null,&quot;K&quot;:null}</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I am wondering if the column Parameter could be split into multiple column and hoping to achieve below format</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Value</th>
  <th>A</th>
  <th>B</th>
  <th>C</th>
  <th>D</th>
  <th>E</th>
  <th>F</th>
  <th>G</th>
  <th>H</th>
  <th>I</th>
  <th>J</th>
  <th>K</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>999-99-9999</td>
  <td></td>
  <td>dfsnl</td>
  <td>dfdfs</td>
  <td>dfdfs</td>
  <td></td>
  <td>dfssdfsdfdsf</td>
  <td></td>
  <td>dfdsf,dfssfddfsdsffds</td>
  <td>73834874378</td>
  <td></td>
  <td></td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Below query does not seem to work for me. Help please?</p>
  <pre><code>SELECT t.Value , t.Parameters       , P.*
  from MYTABLE t
  CROSS APPLY OPENJSON(Parameters) 
  WITH (
  A varchar(10),
  B varchar(10),
  C varchar(10),
  D varchar(10),
  E varchar(10),
  F varchar(10),
  G varchar(10),
  H varchar(10),
  I varchar(10),
  J varchar(10),
  K varchar(10)
  ) P;
  </code></pre>