SQl Server 2008 Function Error

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » SQl Server 2008 Function Error

SQl Server 2008 Function Error

Rate Topic

Display Mode

Topic Options

Author

Message

@SQLFRNDZ

Posted Friday, December 03, 2010 2:12 PM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 12:03 PM
Points: 412, Visits: 862

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
,sum((wait_time_ms-signal_wait_time_ms))as resource_wait_time_ms
,cast(100*(sum(wait_time_ms-signal_wait_time_ms)/sum(wait_time_ms)as numeric(20,2))) as '%resource waits'
from sys.dm_os_wait_stats
GO

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
Suggest me.

Sql Server 2008 Edition.

--SQLFRNDZ

Post #1030157

Suresh B.

Posted Friday, December 03, 2010 3:19 PM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 4:49 AM
Points: 1,075, Visits: 5,119

select sum(signal_wait_time_ms) as signal_waits_time_ms
,CAST(100* (sum(signal_wait_time_ms)/sum(wait_time_ms)) as numeric(20,2)) as [%signal_cpu_waits]
,sum(wait_time_ms-signal_wait_time_ms) as [resource_wait_time_ms]
,cast(100*(sum(wait_time_ms-signal_wait_time_ms)/sum(wait_time_ms)) as numeric(20,2)) as ['%resource waits']
from sys.dm_os_wait_stats

Post #1030179