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.
| Author |
Topic |
|
imughal
Posting Yak Master
192 Posts |
 Posted - 2009-12-30 : 01:52:45
|
| Hi,I am not sure this is right forum to place my question but anyway can anyone help me out.I am working on realtime application using ASP.NET and SQL Server 2005. I received data from different devices. Data Sample is 1 min. For reporting purpose I want to summarize my data on hourly / daily / weekly / monthly /yearly basis.Kindly guide me which technique or procedure to follow in order to summarize data.Thanks |
|
|
Sachin.Nand
2937 Posts |
Posted - 2009-12-30 : 02:07:07
|
| Show us the data.PBUH |
 |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-12-30 : 16:03:09
|
| bring in all the data via a stored procedure to a report in report server then create a drill down grouping on report by hourly / daily / weekly / monthly /yearly basis with each grouping having it's own summation. that is one approach you could use<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
|
|
|
|
Data Summarization Technique