Alternative approaches for Recursive CTE in SQL server. The data is 1 million records. need to calculate the current value based on previous value and iterate through Million records. Please suggest a methods which performs better than Recursive CTE

For this type of question, you help yourself a lot if you post CREATE TABLE statements for an example table together with sample data and the expected results given the sample. The test data set should just be a couple of rows, but it should illustrate all angles of the problem. It is also helpful if you include a short description about the business rules that explains why you want that result. Also, include the output of "SELECT @@version".

With the information you have posted, there is not enough information. I could make a guess, but if that guess is wrong it is frustrating for both you and me.