RE: Anything wrong with the following query?

[MdMush...@cognizant.com]

Guys did you receive this?

Please reply. I am waiting for your valuable suggestions.

 

Thanks

Md  Mushir Alam

 

From: Alam, Md Mushir (Cognizant)
Sent: Monday, August 22, 2011 3:35 PM
To: 'balachandra...@symphonyms.com'; 'pramod.j...@symphonysv.com'; 'ranjan...@thomsonreuters.com'
Subject: Anything wrong with the following query?

 

Guys, I intend to use it in my code, the column used in the join condition is the one to be updated too! Just a one time update for a migration activity.

 

Nothing seems wrong to me,what do you think.

Have you done something similar?

 

UPDATE dbo.A

SET product_id = X.si_product_id

FROM dbo.A L

INNER JOIN B X ON L.product_id = X.legacy_product_id

 

Thanks in advance for any advice J !

 

Thanks

Md  Mushir Alam

 

This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. Any unauthorised review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and may be unlawful.

[प्रमोद जमदग्नि]

try..

UPDATE L

SET product_id = X.si_product_id

FROM dbo.A L

JOIN B X ON L.product_id = X.legacy_product_id

--

प्रमोद जमदग्नि.........................