OPENJSON

Technical Article

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. 

You rated this post out of 5. Change rating

2019-11-25 (first published: )

667 reads

Technical Article

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. 

You rated this post out of 5. Change rating

2019-11-12 (first published: )

1,891 reads

Blogs

Using ThinOptics to Read Data

By

As I’ve aged, I find myself struggling to read many things in my life....

PostgreSQL Events – A Newbies Perspective: #PGSQLPhriday 014

By

For this month’s #PGSQLPhriday 014 blogging event, Pavlo Golub has asked a pretty simple...

Set-Based vs Row-Based Database Code

By

In SQL Server, the terms “set-based” and “row-based” refer to different approaches or styles...

Read the latest Blogs

Forums

Vijaybet Online Casino: Elevate Your Gaming Experience with Rich11!

By VjGian15

Step into a world of unparalleled excitement and luxury with [/url] at Vijaybet Online...

Cali Weed Kaufen

By master234

Drug City ist eine Gruppe von Drogenaktivisten, die erkannt haben, welche Vorteile verschiedene Drogen...

Need help on query - DATEDIFF

By Adelia

Hello, I want to have value Month ago Year ago So far, I've this...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers