Home Forums SQL Server 2005 Development Recursive Queries RE: Recursive Queries

  • October 28, 2009 at 9:00 pm

    #1072200

    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)