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
217 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)
565 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
2013-04-17 (first published: 2013-04-03)
1,428 reads
A Recursion function that was used to apply a Rate percentage to a base amount for the reqested number of times.
2010-10-15 (first published: 2010-10-13)
556 reads
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
The system variable @@ERROR is a quick and easy way to retrieve the error...
Introduction Recently have been working on a “Proof of Concept” task where I wanted...
I've started a series on my blog about coping strategies during the pandemic: https://voiceofthedba.com/tag/life/...
In it's simplest form I want a table that I can use to store...
Hello Everyone, I am new here and I am preparing for microsoft azure certification...
Ask SSC