Thursday, June 21, 2007

Update from comparison of two SQL tables

UPDATE o
SET Amount=Price
FROM orders o JOIN items i ON (o.ItemNumber=i.ItemNumber)

UPDATE o SET EmpActive = 0 FROM ComplianceEmployee o
JOIN ComplianceEmployeeLoad i ON (o.EmpID = i.EmpID)

No comments:

How ASP.NET MVC Works Step by Step

How ASP.NET MVC Works Step by Step Introduction to ASP.NET MVC What is ASP.NET MVC? ASP.NET MVC is a web application framework devel...