Home Forums SQL Server 2008 T-SQL (SS2K8) Looping through table RE: Looping through table

  • September 9, 2012 at 10:38 pm

    #1535536

    CELKO (9/9/2012)

    Look at the CHECK() constraint; this prevent anyone from have more than $250.00 in gift certificates.

    Gosh, Joe. I'm pretty sure that has nothing to do with the problem at hand. Read the narrative again. This would appear to be a running total 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)