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)
386 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,427 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
By Vinay Thakur
Here are the different ways to know the tlog file related information sys.dm_db_log_stats –...
By Will Assaf
Thanks to everyone who joined the BRSSUG for a night all about SQL Server...
By Gerard
This is the third post in a series about modern Data Lake Architecture where...
Hi All, I'm pretty new to azure and am hitting the following problem. I've...
Hey guys, Along with the advancement of science GamesBX offers a series of intelligent...
Hi, Our client have MS-Access database which has more queries written in MS-Access 2010...
Ask SSC