title: JSON into SQL results - SQL Server 2012
body: <p>I have JSON definitions in a SQL table, from there I am trying to parse it into a SQL Server view or a table (anything would be helpful).</p>
  
  <p>LookupJSON table has a single column called definition_JSON and an example of one value looks like this:</p>
  
  <pre><code>{"__type":"userTask","name":"Grade Report","id":4,"directApprove":false,"emailNotification":{"body":"&lt;p&gt;Hi, your Form was successfully submitted! &lt;\/p&gt;","emailType":2,"subject":"Form Submitted"},"lock":false,"submitBool":true, "submitBtn":"Submit"}
  </code></pre>
  
  <p>I just need to get the name, userTask and id as results.</p>
  
  <p>When we tried the following query it didn't like that nested query, it is expecting JSON.</p>
  
  <pre><code>Select * 
  From parseJSON (select top 1 * from LookupJSON)
  </code></pre>
  
  <p>We are using SQL Server 2012.</p>