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
308 reads
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: 2019-11-08)
682 reads
2018-08-10 (first published: 2015-10-05)
4,791 reads
By Devin-Knight
In this month’s Power BI Digest Matt and I will again guide you through...
By gbargsley
Happy Tuesday everyone… Today I am honored to have my first article published on...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Comments posted to this topic are about the item Returning Python Dictionary Values
Comments posted to this topic are about the item The Habits of Better Teams
We are looking to move the SQL server to different datacenter. Since it's a...
Ask SSC