The Self Referencing CTE

Calculating Prime Numbers With One Query

This article looks at calculating prime numbers less than n with one query.

Common Table Expression Basics

Learn the basics of how CTEs work with a few examples in this article.

CTE in SQL Server Examples

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.

Can I create this view?

More CTE Issues

A Minor Problem

CTE in Tempdb

Function and Queries to Convert Hierarchical Adjacency to Nested Json Arrays

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. 

Function and Queries to Convert Hierarchical Adjacency to Nested Json Arrays

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.