In this post I will talk about one annoying thing – how to return a result set containing one to many relationships between tables? In that case you will have multiple primary rows because one row is generated per for each child row. in this post we will see how you can resolve this problem using JSON.

...(read more)

http://blogs.msdn.com/b/sqlserverstorageengine/archive/2015/10/09/returning-rows-formatted-as-json-in-sql-server-queries.aspx