title: Json to temp table in sql server?
body: <p>I want to convert below JSON to SQL <strong>#temp</strong> table.</p>
  
  <pre><code>{
  
    "Person":
  
    {
  
       "Name": "John",
  
       "age": 25,
  
       "Address":
  
       {
          "streetAddress":"21 2nd St New York",
  
          "postal":"10021"
       },
  
       "Numbers":
  
       {
  
          "home":"212 555-1234",
  
          "fax":"646 555-4567"
  
       }
  
    }
  
  }
  </code></pre>
  
  <p><strong>Output:</strong></p>
  
  <pre><code>+-------------+------------+------------------------------+-----------------------+---------------------+--------------------+
  | Person/Name | Person/age | Person/Address/streetAddress | Person/Address/postal | Person/Numbers/home | Person/Numbers/fax |
  +-------------+------------+------------------------------+-----------------------+---------------------+--------------------+
  | John        |         25 | 21 2nd St New York           |                 10021 | 212 555-1234        | 646 555-4567       |
  +-------------+------------+------------------------------+-----------------------+---------------------+--------------------+
  </code></pre>
  
  <p><strong>Questions:</strong></p>
  
  <p>Is there any build-in function to do this work ?</p>
  
  <p>Is there any per-defined CLR available ?</p>
  
  <p>Can we do this with a table valued function ?</p>
  
  <blockquote>
    <p>Currently I'm using this online <a href="http://konklone.io/json/" rel="nofollow">Converter</a> to convert as
    CSV  then uploading it to Database. This one works fine till now , But
    i need to save time by directly uploading to database.</p>
  </blockquote>