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
436 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,257 reads
2013-04-17 (first published: 2013-04-03)
1,432 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)
559 reads
By Steve Jones
When I was presenting at the dataMinds Connect conference, I called on someone in...
By Kevin3NF
I was chatting with Jeff (b|t) on my team yesterday and the context escapes...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hello experts, Is there a ready-made query out there that I could run on...
I want to insert record job allocations only for selected jobs I know the...
I want to insert record job allocations only for selected jobs I know the...
Ask SSC