• Heh... I beg to differ, Steve. You did NOT compromise. You simply made it easier for someone else to do the work and, as it turns out, may have saved your own back in the process. You "enabled" someone else!

    And THAT's the secret to success... "LET them see it YOUR way". In order to do that, you sometimes have to help them along. As David Poole once noted, the extraordinary DBA is the one you seek out first, not use as a last resort.

    By the way, you once suggested that throwing hardware at performance problems was the way to go... why don't you take a ride to the local tractor store and buy one of those hand-crank, wheeled tounge posts and make it so easy for the Mrs. that she'll actually thank you for making it easier to do a "crap job"? 😛 Extraordinary DBA... :hehe:

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