So, just back from the pub after dinner........
Got a table that is populated with 500K records. Requirement is to add a new column PURN, and populate it with a sequential number starting at 12 million.
So PURN would go from 12,000,000 to 12,500,000
Can't reload table, so must update in situ....
Help!!
Not that urgent by the way........