Viewing 4 posts - 1 through 4 (of 4 total)
How would I put it in the this Query?
select (SELECT Count(CallLog.ClosedBy)*1.0 From [Support].[dbo].[CallLog] WHERE ClosedDate Between '2005-01-07' and '2010-01-08')
/
(SELECT Count(CallLog.RecvdBy)*1.0 From [Support].[dbo].[CallLog] WHERE RecvdDate Between '2005-01-07' and '2010-01-09') *100...
November 9, 2009 at 7:56 am
I am not sure how to do either of those I am about a week into learning / using SQL, sorry I am a newbie
November 6, 2009 at 6:55 am
select (SELECT Count(CallLog.ClosedBy)*1 AS Tracker From CallLog WHERE ClosedDate Between '2009-09-01' and '2009-10-30'and Tracker = 'Troy')
/
(Select Count(CallLog.RecvdBy)*1 AS Tracker From CallLog WHERE RecvdDate Between '2009-09-01' and '2009-10-30' and Tracker =...
November 3, 2009 at 1:25 pm
That gives me a
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '('.
So I changed to )
and I get 0 but that is not the right value
November 3, 2009 at 1:20 pm
Viewing 4 posts - 1 through 4 (of 4 total)