How to update multiple columns from one table with values to another table

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hi,

I have to update two table values at same time. In first table current values will be store. In second table previous values (ie.before edited values) should be store. I can do this for one value only. But i want to update multiple column values in single query. If you have any idea please guide me. I don't know exactly that syntax. I tried this. If any mistake please correct me.

SQL

UPDATE rskpcfceditlog SET
            rskpcfceditlog.pcfcbankref = (SELECT rskpcfc.pcfcbankref FROM rskpcfc WHERE
            rskpcfc.pcfcid = rskpcfceditlog.pcfcid)
            rskpcfceditlog.actype = (SELECT rskpcfc.pcfcbankref,rskpcfc.actype FROM rskpcfc WHERE
            rskpcfc.pcfcid = rskpcfceditlog.pcfcid)
            WHERE EXISTS (SELECT rskpcfc.pcfcbankref,rskpcfc.actype FROM rskpcfc WHERE rskpcfc.pcfcid = rskpcfceditlog.pcfcid and rskpcfceditlog.pcfcid=@cond1);

if i do this for one value it will work. But i have to do multiple columns.

Thanks.

Posted 10-Feb-12 22:24pm

Jayanthi-SE

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Costica U · Accepted Answer · 2012-02-11T02:00:00

Solution 1

You can try this

SQL

UPDATE  rskpcfceditlog
SET     pcfcbankref = rskpcfc.pcfcbankref,
        actype      = rskpcfc.actype
        --, add more columns here
FROM    rskpcfceditlog
JOIN    rskpcfc
        ON rskpcfc.pcfcid = rskpcfceditlog.pcfcid
WHERE   rskpcfceditlog.pcfcid   = @cond1

Posted 11-Feb-12 2:00am

Costica U

Comments

Jayanthi-SE 12-Feb-12 23:06pm

Hi,

Thanks a lot, its working