Forum Replies Created

Viewing 4 posts - 1 through 4 (of 4 total)

  • RE: No Decimal in Reults

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

  • RE: No Decimal in Reults

    I am not sure how to do either of those I am about a week into learning / using SQL, sorry I am a newbie

  • RE: Divide Results

    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 =...

  • RE: Divide Results

    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

Viewing 4 posts - 1 through 4 (of 4 total)