ozemondaz

That worked! It didn't work on the server based report writer but worked fine with the web based report writer. Also something is a little weird with the output of the report: 2/1/2014 12:00:00 AM 2/1/2014 12:59:59 AM <-------- 2/1/2014 2:00:00 AM 2/1/2014 3:00:00 AM 2/1/2014 3:59:59 AM <------- Every couple of hours it…

I'm no SQL guru either and that does seem like a brilliant idea but I'm having problems finding out where to put those lines. I keep getting query not valid.

Thanks again Rob, I'll submit a ticket with them!

Thanks Leon, I got it to work with your notes on Re: Help Regarding Alerts. The suppression tab is very deceiving. Thank you

I have changed it a bit. I'm now trying to pull the average for every hour of last month and this is what I have. However this only shows me every hour on February 1st. Also if this helps at all I'm doing this in solar winds report writer. SELECT Convert(DateTime,Floor(Cast((DateTime) as Float)*24)/24,0) AS SummaryDate,…

Hello All, I'm looking for some help, right now I have this: DECLARE @StartDate DateTime DECLARE @EndDate DateTime SET @StartDate = DATEADD(d, DATEDIFF(d, 0, DATEADD(m, -1, DATEADD(d, 1 - day(getdate()), getdate()))), 0) SET @EndDate = DATEADD(ms, -2,DATEADD(d, DATEDIFF(d, 0, DATEADD(d, 1 - day(getdate()), getdate())), 0))…