I have a table with an identity insert column. The table currently has 220,000 records
I need to backfill this table with say 1 million records starting the Id at one
Then I need to change the current 220,00 records which go from Id 1 - Id 220,000 to
reflect the backfill
So I want no gaps at all with my Id's
So my table should start at one and go to 1,220,000 in order
How would I go about accomplishing this task?