CUMULATIVE COLUMN SORTED BY DATE.

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)

CUMULATIVE COLUMN SORTED BY DATE.

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-08-06 : 09:25:03

Atif writes "DEAR SIR,

I AM PREPARING A BANK APPLICATION IN VISUAL BASIC AND SQL SERVER. IN THE LEDGERS ACCOUNT TABLE THE VALUES OF CUMULATIVE COLUMN SHOULD BE SORTED BY DATE.
HOW CAN I GET THE VALUES OF FOLLOWING CUMULATIVE SQL QUERY SORTED BY DATE?

SELECT DayCount,
Sales,
Sales+COALESCE((SELECT SUM(Sales)
FROM Sales b
WHERE b.DayCount < a.DayCount),0)
AS RunningTotal
FROM Sales a
ORDER BY DayCount

OR TELL ME ANOTHER WAY TO GET THE CUMULATIVE COLUMN SORTED BY DATE. I WOULD BE VERY THANKFULL TO YOU.

LOOKING FORWARD TO RECEIVE YOUR NICE RESPONSE.

THANKING YOU."

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-08-06 : 09:27:02

WELL, ONCE MY EARS STOPPED RINGING, I FOUND THIS ARTICLE HERE:

http://www.sqlteam.com/item.asp?ItemID=3856

I THINK IT WILL WORK FOR YOU!

In the future, please do not post in all capital letters. Thank you.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources