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-25 (first published: 2019-11-24)
740 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)
2,029 reads
2013-04-17 (first published: 2013-04-03)
1,445 reads
A Recursion function that was used to apply a Rate percentage to a base amount for the reqested number of times.
2010-10-28 (first published: 2010-10-13)
563 reads
As AI continues to evolve, many of us are looking for ways to leverage...
By Steve Jones
I was chatting with a customer recently and they wanted to know which host...
Yeah, yeah, second AI post in a row. I promise not to make a...
Hi everyone My SSIS package will not log to sysssislog. I am not sure...
Dear All, In one of the server its repeatedly restarting sqlserver services and not...
I want to store database files on a file share for a SQL Server 2017 instance. Can I use \\fileserver\D$ as a location?
See possible answers