Reorder My Rows

Howdie y'all,

Im adding rows to my database like this:

GroupID = IdentityGroupUser = UserIdGroupColumn = 1 GroupPosition = Count (*) where UserId = UserId AND Column = 1

Int this way my table looks like this on a certain moment:

1 ; 1 ; 1 ; 02 ; 1 ; 1 ; 13 ; 1 ; 1 ; 24 ; 1 ; 1 ; 3

 

But then i would, for example, like to delete the 3rd row and i like to renumber the last column so form this:1 ; 1 ; 1 ; 02 ; 1 ; 1 ; 14 ; 1 ; 1 ; 3 <- this is my problem

to this:1 ; 1 ; 1 ; 02 ; 1 ; 1 ; 14 ; 1 ; 1 ; 2 <- here it is solved

 

Whats the simplest sql stored procedure to perform this reordering task???

Thanks,

Wes