2021-09-24
375 reads
2021-09-24
375 reads
2021-09-17
502 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-25 (first published: 2019-11-24)
485 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,472 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,444 reads
By Steve Jones
I wrote recently about making a HEAD utility to find the top few lines...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Jen McCown
Pete Wilkinson’s book “Unstoppable” finally made visualizations and goals make sense to me. Here's a...
Hi, I'm struggling to solve this problem....I hope will get a answer here. count,...
Hello guys, I hope you're all great and healthy I would love to learn...
The following code creates a table with the following watermark_value column: DROP TABLE IF...