Home Forums SQL Server 2008 SQL Server 2008 - General Sum function where field = RE: Sum function where field =
masarzdenka
SSC Enthusiast
Points: 161
More actions
May 7, 2014 at 3:58 pm
#1711724
I think it needs to be done through lookup, so it looks where wait_status="within target" and takes a value from "surgical_case_count" (which is another column) and sums it up.
I just don't know how to write the expression...