advantage-database-server

Update multiple values in a single statement

September 1, 2023 by Tarik

Try this: Update MasterTbl Set TotalX = Sum(D.X), TotalY = Sum(D.Y), TotalZ = Sum(D.Z) From MasterTbl M Join DetailTbl D On D.MasterID = M.MasterID Depending on which database you are using, if that doesn’t work, then try this (this is non-standard SQL but legal in SQL Server): Update M Set TotalX = Sum(D.X), TotalY = … Read more

How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?

December 30, 2022 by Tarik

You need to identify the primary key in TableA in order to delete the correct record. The primary key may be a single column or a combination of several columns that uniquely identifies a row in the table. If there is no primary key, then the ROWID pseudo column may be used as the primary … Read more