Yes, smth like this:

alter table MyTable drop constraint PK_INK_NEXT_OPERATION;

alter table MyTable alter column operation_id int not null

alter table MyTable add constraint PK_INK_NEXT_OPERATION primary key (operation_id);

If it is supposed to work on a really long strings...

Jeff Moden,

Wonderful note about set statistics time! Never heard of it.

"Try to beat it using any form of "all in one query" code."

Here you go!

Sample Data (one million rows of...