FOR JSON

Function and Queries to Convert Hierarchical Adjacency to Nested Json Arrays

  • Script

This script converts hierarchical adjacency into nested json rows which contain the recursive "downlines" of each node.  The table-valued function treats each row in the original adjacency as the root node in a recursive common table expression. 

2019-11-24

142 reads

Function and Queries to Convert Hierarchical Adjacency to Nested Json Arrays

  • Script

This script converts hierarchical adjacency into nested json rows which contain the recursive "downlines" of each node.  The table-valued function treats each row in the original adjacency as the root node in a recursive common table expression. 

2019-11-12 (first published: )

526 reads

Function and Queries to Convert Hierarchical Adjacency to Nested Json Arrays

  • Revision

This script converts hierarchical adjacency into nested json rows which contain the recursive "downlines" of each node.  The table-valued function treats each row in the original adjacency as the root node in a recursive common table expression. 

2019-11-08

1 reads

Blogs

AWS RDS SQL Server Announcements - 2019

By

1.    Amazon RDS SQL Server Supports differential and log and restores: https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-sql-server-now-supports-differential-restores-and-log-restores/  2.    Amazon RDS SQL...

AWS RDS SQL Server Version List

By

AWS RDS SQL Server 2017 Builds RDS...

What is a strong password anyway?

By

Background Fellow Microsoft MVP Troy Hunt (blog | Twitter) has been operating the website Have...

Read the latest Blogs

Forums

Looking for SQL Code

By patla4u

Hi I am having situation where I would like to update the existing data...

Looking for SQL Code

By patla4u

Hi I am having situation where I would like to update the existing data...

SQL Server new Linked Server

By Bristool123

hello my friends. I have a suuuuuper weird question about sql server, at my...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers