SQLServerCentral » Latest topics
single code
Hi,
Application is using below logic .
(sum(CASE WHEN a.RESERVEDOLLAR > 0 THEN a.RESERVEDOLLAR*a.STR_WEIGHT ELSE NULL END)) FINANCE1
(sum(case when a.RESERVEDOLLAR > 0 then a.STR_WEIGHT else NULL end)) FINANCE2
Application is using below logic .
(sum(CASE WHEN a.RESERVEDOLLAR > 0 THEN a.RESERVEDOLLAR*a.STR_WEIGHT ELSE NULL END)) FINANCE1
(sum(case when a.RESERVEDOLLAR > 0 then a.STR_WEIGHT else NULL end)) FINANCE2
No comments:
Post a Comment