Running Total cursor - SQL Server Forums

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

Transact-SQL (2000)

Running Total cursor

Author

Topic

anaylor01
Starting Member

28 Posts

Posted - 2006-04-16 : 11:14:27

I have two tables. ID table that has these fields
Code_id,YearPeriod, ReachedDate fields. And table
Amount that has Code_id,Amount,Date fields. What I
need to do is write a cursor that when the
amount.Amount adds up to $100.00 it Updates the
ReachedDate in the ID table to the amount.date fields
value of that record. Any help would be greatly appreciated.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-04-16 : 11:15:11

see here http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6027

mmarovic
Aged Yak Warrior

518 Posts

Posted - 2006-04-16 : 13:21:47

http://www.sql-server-performance.com/mm_cursor_friendly_problem.asp

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-04-17 : 02:41:12

Where do you want to show the data?
You dont need to update the column with running total. If you use Reports, make use of its running total feature

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources