From SQL Team – Roger writes "Is there a way to retrive a field value from the previously read row in order to use it to calculate a field in the current row . . ." Check out the answer.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help