Forum Replies Created

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

  • RE: How to fix this query?

    Jonathan AC Roberts - Tuesday, June 19, 2018 5:52 AM

    SELECT a.SQLInstance,
       a.DBName,
       Max(a.SvcStartDate) as MaxSvcStartDate,
       Sum(a.DaysUpTime) as SumDaysUptime
    FROM #tbla a
    WHERE...

    June 19, 2018 at 6:10 am

    #1994426

  • RE: How to fix this query?

    Updating for anyone interested, if I insert a dummy/seed row in the input table set to USED = 1, DaysUpTime = 0, my query returns the correct results.  It's a...

    June 19, 2018 at 5:10 am

    #1994415

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