I defined a temp table and got it working.

Thanks for all your help.

-NS.

I do not have any sequential value as the 'year' in the above example and hence it can't be sorted on a field to get the sum of all previous...

I tried this and it seems to work and do exactly what i want. however, one thing I am confused is declaring a cursor would lock those rows in the...

In this case, the types are not so well defined that I can do a two step update. AS in, The total at LineType 'F' need not be just a...

Heres the problem in further detail.

Create Table #tbl

{

RowNo INT,

Type VARCHAR(2), -- This field is to identify the type of record(Detail, SubTotal, FinalTotal)

Amount MONEY,

TotalRowNo INT

}

Example:

Insert INTO #tbl

VALUES (1,'D',10.00,5)

The...

Thanks William. That worked gr8!!!

Thanks for your reply. I think the solution to use the temp table will work for me as i have n status values to check and i will have to...

I dont think the first option will help me. I tried doing it but didnt get the desired result.

In fact the @status can have N number of...

Figured out. Thanks for the prompt reply.

Could you please show me an example.