`
Par2: Totalling a computed field in SQL 2007-12-10 -- J Shankar select ID, sum(QTY), Sum(Extension), Sum(DiscountExt), Sum(Case When discountext = 0 then extension else discountext end) AS 'SoldPrice' from partsolds group by ID Printed May 19, 2024, 9:17 am This article has been viewed/printed 35137 times. |