Home Forums SQL Server 2008 T-SQL (SS2K8) query to get the name of a product with only incremental values in the quantity column RE: query to get the name of a product with only incremental values in the quantity column

  • December 18, 2012 at 9:50 pm

    #1569870

    CELKO (12/18/2012)

    Let's use {snip} and the MySQL year format:

    Since this is an SQL Server forum, let's not. Besides, that break a cardinal rule... though shalt not store dates as character based data.

    Untested

    Why not? You've got the data and the code. Press the {f5} key and run it!

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