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
317 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)
717 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,106 reads
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
By DataOnWheels
This blog covers the content and points to the code used to create the...
By gbargsley
Have you ever been asked to make a schema only copy of a database?...
Comments posted to this topic are about the item Slicing a String in Python
Hello! I am getting this intermittent issue when browsing the report, this error goes...
Hello, Can databases on-Premise Alwayson Availability group of SQL server 2017 failover to Microsoft Azure...
Ask SSC