SUM(CASE WHEN so.Status = 'Delivered' THEN so.NetAmount ELSE 0 END) AS DeliveredSales, SUM(CASE WHEN so.Status IN ('Confirmed', 'InProduction', 'Shipped') THEN so.NetAmount ELSE 0 END) AS ...
ALTER TABLE SalesOrder ADD DiscountAmount DECIMAL(18,2) DEFAULT 0; ALTER TABLE SalesOrderDetail ADD DiscountPercent DECIMAL(5,2) DEFAULT 0; ALTER TABLE SalesOrderDetail ADD DiscountAmount AS ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results