update Record with the last result of a query 1

[yordangs]

Hello to everyone i need to do the next.

i have a table with this fields

Name startPotition Length
Usuario 0 4
CodigoTransaccion 4 5
Fecha 9 7
Hora 16 6


i need create a store procedure to automatically update the next row example usuario begins in potition 0 and have a length from 4 the next row will have a startPotition 4 and its Length its from 5 the next row Fecha will have a startPotition from 9 ans its Length its 7 who i can do to automatically make this Name = Usuario, startPotition =0, Length =4.
Name = CodigoTransaccion ,startPotition =(Usuario startPotition + Usuario Length ), Length = 5.
Name = Fecha, startPotition =(Fecha startPotition + Fecha Length )

any help will be apreciated sorry if a dont explain me well

 

[earthandfire]

For each new record, the startPotition column = the Sum of the Length column, so you can ignore the startPotition column.


Hope this helps