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
2013-04-17 (first published: 2013-04-03)
1,437 reads
A Recursion function that was used to apply a Rate percentage to a base amount for the reqested number of times.
2010-10-28 (first published: 2010-10-13)
559 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