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 2008 Forums
 Transact-SQL (2008)
 Multiple Cumulative Calculation

Author  Topic 

Anishe
Starting Member

1 Post

Posted - 2009-09-22 : 05:08:38
Hai to all,

I have some problem in writing query. I need the report as

DATE TIME RG RG DIFF CUMUL DIFF CUMUL
5/24 6.00 0.443 177.2 123.2 123.2 149 149
6/24 2.00 0.443 177.2 136.2 259.2 118 267
7/24 2.00 0.443 177.2 317.2 576.4 319 586

like this i have to calvulate for more than one cumulative but i wrote the query for this the problem is its coming in descending order for more than one select if i use..

Can any one give me idea for this...


Regards,
Anitha

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-10-01 : 14:45:22
Seems like nobody can understand what you need.
Can you explain more clear?
Giving table structure, sample data, wanted output and maybe what you have coded so far...


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -