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,073 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)
3,209 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...
Hello folks, We had an issue with blocking last week - LOTS of blocking...
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...
Ask SSC