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
311 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)
694 reads
2013-04-17 (first published: 2013-04-03)
1,429 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 Will Assaf
Looking forward to presenting at SQLSaturday Memphis virtually this weekend! Both my wife and I...
By gbargsley
Here we are, another Tuesday!! It is time for our Fourth and final installment...
By Steve Jones
I want PASS to survive. I can say that unequivocally, because this organization has...
Hi, i have a table named as Book_master_tbl having only 10 records and as...
Comments posted to this topic are about the item When one of your DBA...
I'm working to plan a new upgrade to our existing data warehouse infrastructure. We're...
Ask SSC