2023-07-28
555 reads
2023-07-28
555 reads
This article looks at calculating prime numbers less than n with one query.
2023-06-14
4,135 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-25 (first published: 2019-11-24)
649 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,858 reads
2018-11-19
2,937 reads
Learn how to generate lists of column values from multiple rows by grouping and using a recursive CTE. This is a very flexible and easy implementation, compared to using cursors or PIVOT operators.
2015-06-26 (first published: 2013-07-09)
29,782 reads
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...
Widgets provide a way to parameterize notebooks in Databricks. If you need to call...
You can find the slides for my session at Future Data Driven summit at...
Hi. Two node windows clusters Node1 and Node2 and configured alwayson availability group. Will...
Hello, I am trying to split data, looks like there is some special...
Comments posted to this topic are about the item Backing Up a Restoring Database