SQL Server Performance Forum – Threads Archive

Update SQL

Hello, I’ve a question regarding an UPDATE command I have a table A with an average net price and an average brut price I want to update these fields where they are both 0 and take the net and brut price from another table B where the foreign keys are the same. Fe
Table A
ID Col WS ArtID ArtCol ArtWS Net Brut
1 1 1 1 1 1 0 0
2 1 1 2 1 1 0 0
3 1 1 5 1 1 0 0 Table B
ID Col WS ArtID ArtCol ArtWS Net Brut
1 1 1 1 1 1 4 8
2 1 1 2 1 1 5 7
3 1 1 5 1 1 7 7 How can I update the values NET , BRut from table B into table A? Thanks Ralph

UPDATE tableA
SET net=b.net,
brut=b.brut
FROM tableA a JOIN tableB b ON
a.id=b.id
WHERE a.net=0 and a.brut=0

<blockquote id="quote">quote:<hr height="1" noshade id="quote">Originally posted by ralph1972 Hello, I’ve a question regarding an UPDATE command I have a table A with an average net price and an average brut price I want to update these fields where they are both 0 and take the net and brut price from another table B where the foreign keys are the same. Fe Table A ID Col WS ArtID ArtCol ArtWS Net Brut 1 1 1 1 1 1 0 0 2 1 1 2 1 1 0 0 3 1 1 5 1 1 0 0 Table B ID Col WS ArtID ArtCol ArtWS Net Brut 1 1 1 1 1 1 4 8 2 1 1 2 1 1 5 7 3 1 1 5 1 1 7 7 How can I update the values NET , BRut from table B into table A? Thanks Ralph <hr height="1" noshade id="quote"></blockquote id="quote"> Try this: <pre id="code"> Use DatabaseName GO UPDATE A SET NET = b.NET ,Brut = b.Brut FROMTableA A JOINTableB B ONA.ID = B.ID WHEREa.NET = 0 ANDa.Brut = 0 GO </pre id="code"> <pre id="code"> Oops, someone has already posted. [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] Thanks, Name ——— Dilli Grg (1 row(s) affected) </pre id="code">

Thanks for all the help This topic can be closed.

]]>