Viewing 3 posts - 1 through 4 (of 4 total)
Muchas Gracias again ~ Perfecto! *** hugs you ***
--declare @startdate datetime,
--@enddate datetime
select
RM.fldEditedBy as 'User Login',
case Grouping(RM.fldPriorityCode)
when 0 then RM.fldPriorityCode
else 'Total' end as 'Priority',
count(datediff(day,RM.fldRequestDate,RM.fldComCanDate)) as 'Calls Resolved'
from tblRequestMaster RM
where RM.fldPriorityCode...
------------------------------------------------
http://floetichoney.spaces.live.com
------------------------------------------------
May 11, 2007 at 9:51 am
Thank you Gordon for your help ![]()
My code is now looking like this [I'm almost getting there] ::::
--Number of calls resolved by each staff...
------------------------------------------------
http://floetichoney.spaces.live.com
------------------------------------------------
May 11, 2007 at 9:29 am
Thank you very much Lynn that worked perfectly ![]()
------------------------------------------------
http://floetichoney.spaces.live.com
------------------------------------------------
May 10, 2007 at 9:28 am
Viewing 3 posts - 1 through 4 (of 4 total)