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
405 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)
1,072 reads
2018-08-10 (first published: 2015-10-05)
4,823 reads
By todd-32417
The next batch of exciting updates to the block editor is live on WordPress.com....
By Steve Jones
One of the things that I’ve seen crop up at various points in my...
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 Deceptive Visualizations
Hi, I'm trying to modify my SSIS packages to use sftp and since it...
I have included the DDL to re-create the 2 tables in this examples. I...
Ask SSC