Post reply

Update table using store procedure

  • April 16, 2008 at 4:01 pm

    #74890

    I am trying to update a table with a values from another table using a store procedure. Can any one tell me the syntax please

    Here is what I am trying to do

    Update tbl1 set tbl1.address = tbl2.address where tbl1.cuid = tbl2.cuid

    How can I put this in stored procedure an create a job?

    Please help.

  • April 16, 2008 at 4:05 pm

    #803368

    Update tbl1

    set

    address = tbl2.address

    from

    tbl1

    join

    tbl2

    on tbl1.cuid = tbl2.cuid

  • April 17, 2008 at 3:26 pm

    #804031

    Thank you,

    Yes this works.

    Appreciate your help.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply