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,157 reads
Learn the basics of how CTEs work with a few examples in this article.
2023-05-31 (first published: 2023-05-19)
5,303 reads
In this article we cover what a Common Table Expression CTE is and how to write a CTE for doing selects, inserts, deletes, updates and more.
2021-06-02
2020-12-29
646 reads
2020-12-22
838 reads
2020-12-15
631 reads
2020-06-18
820 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,859 reads
By Steve Jones
We’ve been doing some events as part of the Redgate Roadshow, and at one...
By James Serra
As I have mentioned in prior blog posts, I have been writing a data...
By alevyinroc
I’m happy to announce that I will be speaking at SQL Saturday Boston on...
HI We have a small utility that is giving us a "#table is missing...
@reportParameter 1008,1009,1011,1014 values need to insert to #Table Note: @reportParameter is not returning values...
Hi All, As part of security compliance, we are told to audit DML &...