Recursive Queries

Question

Post reply

Recursive Queries

martin.edward

SSCommitted

Points: 1645
More actions
October 27, 2009 at 10:17 am

#103847

Hello,
I am in the process of creating a recursive query, but have no idea on the basics i.e. recursion,looping through sql statements etc.
Could some give me a drill down ?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Lewis Dowson SSC Eights! Points: 988 More actions · Answer 1

Hi,

Can you give a llittle more info on exactly what it is you need a loop for?

For the time being have a look at the following article (SQL Server 2005, wont work on 2000)

http://msdn.microsoft.com/en-us/library/ms186243.aspx

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

Your question is pretty open-ended. It would help us in helping you if you could provide more specifics regarding your problem. Please take the time to also read the first article I reference below in my signature block regarding asking for assistance. if you follow the instructions in that article you we get much better answers to your questions.

dmoldovan SSCertifiable Points: 6334 More actions · Answer 3

If you're interested in how the recursive queries work, see

http://sqlblog.com/blogs/linchi_shea/archive/2009/04/16/recursive-sql-queries-how-do-they-work.aspx

Jeff Moden SSC Guru Points: 1004312 More actions · Answer 4

martin.edward (10/27/2009)
Hello,
I am in the process of creating a recursive query, but have no idea on the basics i.e. recursion,looping through sql statements etc.
Could some give me a drill down ?

The only time you should use recursion is for hierarchies. The only time you should use a loop is for flow control across tables or databases... that leaves out 99.9% of all queries.

Rather than learn the wrong way to do things by learning recursion and loops first, take a look at the following article for an alternative to needing most loops...

http://www.sqlservercentral.com/articles/T-SQL/62867/

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)