i have 6 rows in a table
so what i need to do is i will be inserting the data from other table into this table using sp ...
so i have a column name sortorder in this table i need to have values as 1,2,3,4,5,6 so that i can sort by sortorder
...
so when i delete the rows in my table and insert it again from other table i need to get the same 1,2,3,4,5,6 but i am getting 7,8,9,10,11,12
Thanks,
Chinna
Its the Journey which gives you Happiness not the Destination-- Dan Millman