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)
94 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
An example of exporting and importing table data with JSON in Azure and SQL Server 2016.
2017-06-09 (first published: 2016-05-05)
2,959 reads
By Vinay Thakur
SQL Server Management studio is now can be installed separately not part of SQL...
By James-Serra
Almost lost in all the announcements from Ignite was a bunch of amazing new...
For those who don’t know, last week was the PASS Summit. It’s an amazing...
In the below SQL statement (also attached as DOC file) it has been...
Comments posted to this topic are about the item Computed Column Indexes
Ask SSC