What Exactly Is a CTE in T-SQL? A Comprehensive Guide with 7 Examples
Learn how to use CTEs through the use of a number of examples.
2023-10-20
9,904 reads
CTE
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.
2021-06-02
Navigating Trees With CTE
Introduction This article shows how common table expressions (CTE) in SQL Server are naturally suited for navigating trees, such as finding its longest path, or diameter. Recall that a tree is an undirected graph where unique paths exist between any two nodes (i.e. vertices). Any node may be selected as its top node, with its […]
2021-04-19
7,863 reads
A Solution for the Bin Packing Problem
A detailed description of a technique for the the solution of the Bin Packing Problem, that involves a recursive CTE and Window functions
2020-05-14 (first published: 2020-04-23)
5,586 reads
Blogs
Secret management using Pulumi ESC SDK and Azure Key Vault
This is a submission for the Pulumi Deploy and Document Challenge: Shhh, It’s a Secret!What...
The Book of Redgate–Being Reasonable
By Steve Jones
As a part of the Book of Redgate, we have a series of (red,...
Azure Data Factory Pipeline Debugging Fails with BadRequest
I recently had a new pipeline fail. It was actually a copy of an...
Forums
The User Login
Comments posted to this topic are about the item The User Login
Using Feature Flags
Comments posted to this topic are about the item Using Feature Flags
Understanding UNION and UNION ALL in SQL Server
Comments posted to this topic are about the item Understanding UNION and UNION ALL...
Question of the Day
The User Login
When I create a user in a SQL Server 2022 database, on which types of logins in the master database can it be based?
See possible answers