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
137 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)
520 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)
555 reads
Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than...
By Will Assaf
Working on a SQL 2017 database where an external, non-Microsoft application has direct access...
Last year Azure SQL Database Managed Instance saw the introduction of bring your own...
Comments posted to this topic are about the item Towards an efficient interface between...
How to handle date on temp table when is null or not ? I...
Thanks for fielding this question in advance: We are searching for a Microsoft SQL...
Ask SSC