Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Average every ...

Author  Topic  yuriv Starting Member 3 Posts Posted - 2000-12-08 : 14:48:02 I have a Table (SQL Server 2000) with two fields:Time(datetime) and Value(every 15-20 minutes). How could I select (-create new table) Time and Value_Av,where Value_Av is average in every three (for ex.)hour's period ? Thanks in advance