I have a table that looks like this....there's other columns as well. I
need to re-sequence these step and sub_step numbers. How can I use a
cursor the get the desired affect? Any help would be greatly
appreciated....

what I have now:
step sub_step
1 1
1 2
3 1
3 2
3 4
4 1
4 3

what I need:
step sub_step
1 1
1 2
2 1
2 2
2 3
3 1
3 2

Patrick Conahan

MS Sql Server LazyDBA home page