Query: Update GLMovement LineNumber

ALTER TABLE GLMovement ADD Id INT IDENTITY(1,1)

Update [GLMovement] Set [LineNumber] = [ResGLMovement].[ResLineNumber]
from (Select [DBId] as [ResDBId], [Id] as [ResId], ROW_NUMBER() OVER(ORDER BY [GLMovement].[LineNumber]) as [ResLineNumber] from [GLMovement] where [GLPeriodId] = X and [EntryNumber] = Y) as [ResGLMovement] INNER JOIN [GLMovement] ON [ResGLMovement].[ResId] = [GLMovement].[Id]