Split String Function
This In-line Table Valued Function returns a table with individual records parsed from a string.
2016-08-26 (first published: 2015-04-01)
4,882 reads
Recursion
2013-09-17 (first published: 2013-09-06)
1,436 reads
Using a Recursive CTE to Generate a List
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)
28,966 reads
Unpack an Integer with SQL Server Recursion
Starting with SQL Server 2005, developers have had recursion available as a T-SQL language feature. This article describes recursion and its SQL Server implementations, complete with examples. It also includes SQL Server functions and a stored procedure that unpacks, or parses, an integer into its multiple-of-two components.
2013-04-26
3,186 reads
2013-04-17 (first published: 2013-04-03)
1,437 reads
Exploring Recursive CTEs by Example
Recursive CTEs can be confusing and scary, so examining some non-standard examples may cast light upon these shadowy demons.
2014-07-25 (first published: 2012-07-17)
25,309 reads
Using Recursion and Date Tables to Simplify Date Logic
Learn to simplify date logic using date tables and recursion in T-SQL with this article from David Beardsley.
2011-12-13
11,155 reads
Hidden RBAR: Counting with Recursive CTE's
"Counting" is essential to many high performance code techniques. SQL Server MVP, Jeff Moden, shows us how to make sure that we're "Counting" and not "Crippling" our trick-code.
2011-08-08
19,394 reads
Common table expressions and circular references
Finding circular references that are stopping your CTE from working.
2013-09-02 (first published: 2011-01-31)
18,460 reads
Merge error handling
Learn to use recursion to determine which row caused your merge statement to fail in this article.
2010-11-02
13,849 reads
Blogs
Flyway Desktop Projects for My PoC
By Steve Jones
In a previous post, I set up the basic databases for the PoC project...
Daily Coping 30 Jan 2023
By Steve Jones
Today’s coping tip is to plan something fun and invite others to join you....
Migrating or Recovering a TDE Protected Database
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...
Forums
migration
Has anyone migrated databases from on premise SQL Server to Azure Managed instance? If...
This code works, but am requesting help with the code.
Hello everyone. I don't post here often even though I am constantly on the...
Ask SSC