Home Forums SQL Server 2008 SQL Server 2008 - General Sum function where field = RE: Sum function where field =

  • May 7, 2014 at 3:06 pm

    #1711707

    You have just written what you need:

    masarzdenka (5/7/2014)

    Sum ... surgical_case_count where wait_status is "within target"...

    select Sum(surgical_case_count)

    where wait_status = 'within target'