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
221 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)
569 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)
3,025 reads
Sometimes in life you have to do things you really don’t like to do....
By HamishWatson
Welcome to the first April edition of T-SQL Tuesday. I’m honoured to be hosting...
By Steve Jones
Last week went a little crazy, and I learned something: don’t post a Zoom...
Hi, I need to include a very simple schema in all of my database...
This is my first time dealing with CLR assemblies and we have setup some...
Hi, I have a requirement to convert a date value like '7th March 2020' ...
Ask SSC