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)
 Specific cursor requirement

Author  Topic 

chandan_joshi80
Starting Member

30 Posts

Posted - 2008-07-01 : 08:12:01
OpeningAmount .00 .00 .00 .00 .00 1350.00
June 1300.00 1500.00 .00 200.00 .00 1550.00

I use amount(1350) of first row in second row to calculate total amount for a period.I store all these type of values in a temp table after that i apply cursor to manipulate data at each row.
Is it good programming practice to use cursor here ,if not then what should i apply here.
Actually this question for sql 2000 forum

chandan Joshi

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-07-01 : 08:25:00
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx
Go to Top of Page
   

- Advertisement -