MS SQL

UPDATE with INNER JOIN

Please support our MS SQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Sep 2008

Posts: 1

Reputation: rdneira is an unknown quantity at this point

Solved Threads: 0

rdneira

Offline

Newbie Poster

UPDATE with INNER JOIN

Sep 28th, 2008

I have the next query, but it doesn't update when I have but of a product with the same code in the table detallefacturas

UPDATE dbo.Kardex SET dbo.Kardex.SaldoDocumental = dbo.Kardex.SaldoDocumental + dbo.DetalleFacturas.Cantidad
FROM dbo.Kardex INNER JOIN dbo.DetalleFacturas ON
(dbo.Kardex.CodigoZofriID = dbo.DetalleFacturas.CodigoZofriID) WHERE dbo.DetalleFacturas.FacturaID = @FacturaID

for example.
DetalleFacturas
Item CodigoZofriID Cantidad
1 001-08-000124-001 10
2 001-08-000124-001 20
3 001-08-000222-001 5

Kardex
CodigoZofriID IngresoDocumental SaldoDocumental
001-08-000124-001 400 370
001-08-000222-001 100 95

once made the query this is what see

Kardex
CodigoZofriID IngresoDocumental SaldoDocumental
001-08-000124-001 400 380 BAD
001-08-000222-001 100 100 OK

thanks. Rodrigo.

•

Join Date: Oct 2009

Posts: 1

Reputation: AndrewM001 is an unknown quantity at this point

Solved Threads: 0

AndrewM001 AndrewM001 is offline

Offline

Newbie Poster

15 Days Ago

Have you tried:

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
UPDATE dbo.Kardex
  SET dbo.Kardex.SaldoDocumental = dbo.Kardex.SaldoDocumental + dbo.DetalleFacturas.Cantidad
FROM dbo.DetalleFacturas
WHERE dbo.DetalleFacturas.FacturaID = @FacturaID 
  AND dbo.Kardex.CodigoZofriID = dbo.DetalleFacturas.CodigoZofriID
UPDATE dbo.Kardex
  SET dbo.Kardex.SaldoDocumental = dbo.Kardex.SaldoDocumental + dbo.DetalleFacturas.Cantidad
FROM dbo.DetalleFacturas
WHERE dbo.DetalleFacturas.FacturaID = @FacturaID 
  AND dbo.Kardex.CodigoZofriID = dbo.DetalleFacturas.CodigoZofriID