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
128 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)
513 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,981 reads
By James-Serra
As a followup to my blog post Azure Data Lake Store Gen2 is GA,...
As always, the scripts in this post can also be found on our Git...
I ran into a rather obscure permissions problem the other day. Since I wasn’t...
Hi all, I've never used mssql express before but we had a small intranet...
Looking for memory optimized tables. How would we know that the approx memory is...
I know that this is a long article, so, I totally understand if there...
Ask SSC