update two rows in one query

Expand Post »

UPDATE table1
SET ID,[DESC] =
(SELECT ID,[DESC]
FROM tmptable
WHERE tmptable.ID_SUN = table1.ID_SUN)
WHEREEXISTS
( SELECT ID,[DESC]
FROM tmptable
WHERE tmptable.ID_SUN = [Table1].ID_SUN)
I tired this but i coudn't uptade tow columns at once
do i need to seperate them or i have any mistake?

Similar Threads

how to delete duplicate record in a table by using SQL query in MS SQL
updating multiple rows with one form in PHP
vb6 update record in the database in Visual Basic 4 / 5 / 6
help a newbie? mySQL find & replace in MySQL
Double MySQL Query in PHP

rchokler

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since May 2007

Permalink

May 13th, 2007

Re: update two rows in one query

Yes, you need to separate them. The syntax should be more like

MS SQL Syntax (Toggle Plain Text)

UPDATE SomeTable
SET   Column1 = SomeValue1,
        Column2 = SomeValue2,
        Column3  = ....

It doesn't look like you need a subquery either. A simple join should be sufficient. Something like

MS SQL Syntax (Toggle Plain Text)
UPDATE t1
SET    t1.ID = tmp.ID,
         t1.[DESC] = tmp.[DESC]
FROM   
        tmptable tmp INNER JOIN table1 t1
        ON tmp.ID_SUN = t1.ID_SUN
UPDATE t1
SET    t1.ID = tmp.ID,
         t1.[DESC] = tmp.[DESC]
FROM   
        tmptable tmp INNER JOIN table1 t1
        ON tmp.ID_SUN = t1.ID_SUN

cfAllie

Reputation Points: 10

Solved Threads: 0

Unverified User

Offline

28 posts
since Mar 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: Query Total Asset

Next Thread in MS SQL Forum Timeline: Checking for banned words

DaniWeb Message

Cancel Changes

User Name
Password