Home Forums SQL Server 2005 Development Data in date column to decrement with one RE: Data in date column to decrement with one

  • July 5, 2013 at 5:39 pm

    #1630203

    asifejaz (7/4/2013)

    thanks for your quick response. really appreciate that.

    This will solve it but urpose is not achieved. i am using a cursor to fetch records with combination of primary keys and want to change the date to start off from 2013-05-301 . means

    table is having 57000 records.

    it will pick first row based on pk and changed its date from 2013-05-31 it is to 2013-05-30 then next row

    changing it from 2013-05-30 to 2013-05-329 and so on till it finished all resulting in all unique columns.

    hope you understand the situation 🙁

    You do not need the cursor for that simple task. As already asked, what else is the cursor doing? At this point, I recommend you post your code and as much information about the columns in the table the cursor is using as possible.

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