I'm running a query like this
select sum(signal_wait_time_ms) as signal_waits_time_ms
,CAST(100* (signal_wait_time_ms/sum(wait_time_ms as numeric(20,2)))) as %signal_cpu_waits
,cast(100*(sum(wait_time_ms-signal_wait_time_ms)/sum(wait_time_ms)as numeric(20,2))) as '%resource waits'
I'm getting the error:
Msg 195, Level 15, State 10, Line 2
'sum' is not a recognized built-in function name.
I used to use it before it works fine in 2005 but when I try in 2008 version
I'm getting this error
Sql Server 2008 Edition.