Home Forums SQL Server 2008 SQL Server 2008 Administration Query taking over 50 mins; Stuff with XML Path RE: Query taking over 50 mins; Stuff with XML Path

  • October 9, 2013 at 5:00 pm

    #1657341

    Eshika (10/9/2013)

    Bellow is the code:

    I think maybe not. The "C" derived table doesn't have the "townlist" column that have you in the update list. Also, why are you calculating a "ClliList" when it's not being used anywhere and that same thing goes for the two temp tables you create... they're also not being used anywhere.

    Please help us help you. Read the article that you've been directed to.

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