Please help! im new to SQL and im finding a way of calculating an hourly avg difficult.
This is what i have so far for all the data for the week - but i want an hourly avg instead of every second of everyday between. Please help! thanks
select "computerNa me" , "TimeSample d", "PerformanceCou nterName", "SampledVal ue"
from dbo.SDKPerforma nceview
where computername like 'dmm%' and performancecoun tername like 'total messages submitted'
and timesampled between '2007-05-14 00:00:00' and '2007-05-20 23:59:00'
This is what i have so far for all the data for the week - but i want an hourly avg instead of every second of everyday between. Please help! thanks
select "computerNa me" , "TimeSample d", "PerformanceCou nterName", "SampledVal ue"
from dbo.SDKPerforma nceview
where computername like 'dmm%' and performancecoun tername like 'total messages submitted'
and timesampled between '2007-05-14 00:00:00' and '2007-05-20 23:59:00'