Recursion

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: )

386 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

Transaction log Information gathering

By

Here are the different ways to know the tlog file related information sys.dm_db_log_stats –...

What's New in SQL 2019? at BRSSUG

By

Thanks to everyone who joined the BRSSUG for a night all about SQL Server...

Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 3

By

This is the third post in a series about modern Data Lake Architecture where...

Read the latest Blogs

Forums

Azure file copy creating a directory to hold the renamed file

By Irish-Toon

Hi All, I'm pretty new to azure and am hitting the following problem. I've...

Play smart, properly developed games with Trends Now Defly GamesBX

By GamesBXdaily

Hey guys, Along with the advancement of science GamesBX offers a series of intelligent...

MSAccess to SQLServer Query Conversion

By Whizkid

Hi, Our client have MS-Access database which has more queries written in MS-Access 2010...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers