Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Other SQL Server Topics (2005)  update differes BW Access and SQL

Author  Topic  Antony Starting Member 1 Post Posted - 2009-01-20 : 04:09:14 Hai All, I am doing one migration project, in old one they used MS Access, but now i am using SQL 2005, I got some difference while updating record through a small query. update made by SQL differes from MS Access. Example: UPDATE Table_A SET Table_A.HisBal = Table_B.IBal from Table_A INNER JOIN Table_B on ((Table_A.InV=Table_B.InV)); UPDATE Table_A SET Table_A.PaBal = Table_B.PBal from Table_A INNER JOIN Table_B on ((Table_A.InV=Table_B.InV)); Sample Records: Table_B IBal PBal inv -------- --------- -------- 1251.00 .00 12345 .00 1638.85 12345 After update query executed records in Table_A inv HisBal PaBal ------ --------- --------- 12345 0.00 1251.00 12345 1638.85 0.00 but the same query and same records updated differently in Access, I dont know which one correct sample: IBal PBal inv -------- --------- -------- 1251.00 .00 12345 .00 1638.85 12345 After update query executed records in Table_A inv HisBal PaBal ------ --------- --------- 12345 0.00 1251.00 12345 0.00 1251.00 So kindly tell me why these difference occures, which one is correct. Thanks in Advance Antony