Home Forums SQL Server 2008 SQL Server 2008 - General How do I loop through rows and populate data? RE: How do I loop through rows and populate data?

  • August 2, 2014 at 12:27 am

    #1734575

    thejordans21 (8/1/2014)

    Here is my data.. (I have around 195K of rows)

    Here is a brief snapshot of it:PLANTPLANT_DESCVENDOR

    NOPENULLNOPE

    7010Coquitlam DCPR1

    NOPENULLNOPE

    NOPENULLNOPE

    NOPENULLNOPE

    NOPENULLNOPE

    NOPENULL1014435

    NOPENULL1014435

    NOPENULL1014435

    NOPENULLNOPE

    NOPENULLNOPE

    NOPENULLNOPE

    NOPENULL1014435

    NOPENULL1014435

    NOPENULL1014435

    What I need to happen is that where there is a number for Vendor I need the plant and plant number populated. I have created a temp table that has all the plant and plant desrc in it. The plant and plant desc change further down the lines of data so my next step would be to acocunt for that

    any suggestions?

    What is the PK for this table?

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