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
216 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)
564 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-08
1 reads
2018-08-10 (first published: 2015-10-05)
4,775 reads
By Kamil
Introduction Benni De Jagere is a Senior Data Insights Consultant with a strong focus...
There’s a really simple conundrum that we go through all the time. The best...
Comments posted to this topic are about the item Query Optimization Level
Comments posted to this topic are about the item Now Is a Good Time...
Hi everyone, I have a use case (below) for which I am considering multiple...
Ask SSC