Home Forums SQL Server 2005 SQL Server 2005 Integration Services For loop in sql server RE: For loop in sql server

  • June 23, 2008 at 10:32 am

    #832885

    venki (6/23/2008)

    I got a doubt when I am trying to create a Stored Procedure.

    I am pulling the data i.e recordset by written a query from different tables.

    I supposed to modify the data by taking each row and each column.

    When I searched in Google, I haven't get any link for this. It is giving links to Oracle. That's why I have asked this question.

    Now I used Cursors and while loop and completed the task.

    Thanks a lot for your suggestions.

    I don't know for sure because your description of what you're trying to do is very generic... but I believe you've made a mistake by using a Cursor and While loop instead of some good set based code. Good luck...

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