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
2018-08-10 (first published: 2015-10-05)
4,854 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 have a problem like below one. Give, for each train station, the...
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...
Ask SSC