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 2005 Forums
 Transact-SQL (2005)
 Specific cursor requirement

Author  Topic 

chandan_joshi80
Starting Member

30 Posts

Posted - 2008-07-01 : 08:05:35
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.


chandan Joshi

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-07-01 : 08:11:56
http://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspx



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-07-01 : 08:44:54
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=105840

lol
Go to Top of Page
   

- Advertisement -