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 ...
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 ...
Ars Technica

Recursive SQL Question (SQL Server 2005)

In my VB.Net application, I need to be able to get the string "Hardware:CPU=Intel:Speed=3 ghz" by querying the database table above. I'm almost positive this can be done using recursive SQL or Common ...