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)
668 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,894 reads
By Steve Jones
I posted that I was thinking about the AdventOfCode this year, but wasn’t sure...
It’s me again with my apparently semi-annual blog post. This time we’re going to...
By Steve Jones
I saw an article on this and realized I had no idea how to...
NOTE: The Topic Title probably isn't very good but I wasn't sure how to...
Hey Folks, So I have SQL Transactional Replication set up on a database that's...
Hello, how can I change this code to txt pipe format? $DataSet.Tables[0] | Export-csv...
Ask SSC