title: return data and count as json toghether
body: <p>Consider following table:</p>
  
  <pre><code>[Id: 1, Name: "A1"], [Id: 2, Name: "A2"], ... [Id: 100, Name: "A100"]
  </code></pre>
  
  <p>I need data with Id &lt;= 50, with paging. So I write</p>
  
  <pre><code>select * 
  from data 
  where Id &lt;= 50 order by Id 0 rows fetch next 10 rows only 
  </code></pre>
  
  <p>And then I execute another query</p>
  
  <pre><code>select count(1) 
  from data 
  where Id &lt;= 50
  </code></pre>
  
  <p>Then I return json like this to client</p>
  
  <pre><code>{
     count:50,
     values:[{Id:1, Name:'A1'}, ..., {Id:10,Name:'A10'}]
  }
  </code></pre>
  
  <p>How can I create that json in SQL Server 2016 using <strong>1</strong> select and roundtrip to db only?</p>