Viewing 3 posts - 1 through 4 (of 4 total)
Sorin Petcu (11/12/2007)
UPDATE customersSET passnumber = passnumber + 12000
WHERE passnumber is null
I think all this would have done is set them all to 12000.
November 12, 2007 at 7:54 am
update customersset passNumber = blankCustomers.rowNum + 100000 --big first starting numberfrom customers inner join ( select customerID, row_number() OVER (ORDER BY customerID)...
November 12, 2007 at 7:51 am
Correct me if I'm wrong but your suggestion would prevent the problem from happening in the future which I don't need right now. I need to update all of the...
November 11, 2007 at 1:08 pm
Viewing 3 posts - 1 through 4 (of 4 total)