dbta

An Introduction to Recursive SQL

If you are a SQL programmer, learning recursive SQL techniques can be a boon to your productivity. A recursive query is one that refers to itself. I think the best way to quickly grasp the concept of ...
Ars Technica

SQL Server 2000: Recursive Stored Procedure for Parent-Child relationship

Hey All,<BR><BR>Got a question regarding 2 sprocs I need to make (once I get the first one done the other will be easy cause its just the opposite). Here's the deal: I have a database with table ...
Ars Technica

Any alternative to recursive sql stored procedure?

I'm having an issue with an ASP page occasionally timing out. The specific error is the following:<BR><BR>"*.DBCommand.Execute(): Microsoft OLE DB Provider for SQL ...
GitHub

block-1.3-ctes-advanced-patterns-recursive.md

A CTE is not materialized by default. SQL Server may evaluate the CTE expression once or multiple times depending on what the query optimizer decides. If the CTE is referenced multiple times in the ...
GitHub

Recursion Examples

In this directory you will find my collection of SQL scripts to solve various challenges using recursion. 👓 I am always on the lookout for puzzles that can be solved using recursion. If you have any ...
CIOL

Recursive queries with SQL Server 2000

There is no simple way to create recursive queries that have several levels of data (hierarchical data) in SQL Server 2000. A recursive query is used when you have a parent and child data stored in ...