title: Reading JSON in SQL SERVER 2012
body: <p>In my table empid column containing values like below json format.</p>
  
  <pre><code>row 1-&gt;[{"id":85574},{"id":169794}]
  row 2-&gt;[{"id":180313},{"id":169796},{"id":173467}]
  </code></pre>
  
  <p>i want to display empid for each row one by one like below output.</p>
  
  <p>Output</p>
  
  <pre><code>empid
  85574
  169794
  180313
  169796
  173467
  </code></pre>
  
  <p>I tried below query but it is showing Sub query returned more than 1 value</p>
  
  <pre><code>select 
  (
  SELECT StringValue from parseJSON(v1.empid) 
  where Name='id'
  ) from emp v1 where year=1994 
  </code></pre>