Home Forums SQL Server 2008 T-SQL (SS2K8) Solve Problems Using Recursive CTE RE: Solve Problems Using Recursive CTE

  • December 6, 2012 at 1:04 pm

    #1566328

    bj_shenglong (12/6/2012)

    I put the date into the query to make the Island query similar to the last query you posted. That query will only report the first consecutive month for each name, however the Island query will report all consecutive months in the period for a name. For example

    That is what I said in previous post. This perticular task is to find when someone are qualified at his first time. So, recursion will search at beginning and stop searching after reaching the goal.

    I've haven't looked at the queries in any great detail but I'm thinking that add TOP 1 would easily solve such a problem.

    --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)