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)
433 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
2018-08-10 (first published: 2015-10-05)
4,761 reads
By SQLPals
If your organization uses a password policy (there are very good odds these days...
Anecdotally any session_id that’s 50 or less is going to be a system session...
In this episode, David looks at how we can encrypt our SQL Server backup...
Comments posted to this topic are about the item Numeric and Decimal, which is...
Hi I have a particular drive on one of my sql servers, it's gotten...
Hi all I've got a weird one here. We have a multi-dimensional cube...
Ask SSC