Adding a sequence number

[MaumeeScott]

I need to add a sequence number to an existing table. The primary key is alpha-numberic which is causing me problems when I attempt to select a certain number of records. What I am trying to do is to select the first 50K records or records 50K through 100K etc.

I thought about taking an existing field that is not being used and adding a sequence number which I could then use in my select statement.

Thanks
Scott

 

[AlexCuse]

All you need to do is insert a new column in Enerprise Mangler design view and make it data type int. Then select 'yes' where it says 'Identity' and leave the seed and increment both at one.

hope this helps,

Alex

Professor: But what about your superintelligence?
Gunther: When I had that there was too much pressure to use it. All I want out of life is to be a monkey of moderate intelligence who wears a suit. That's why I've decided to transfer to Business School.
Professor: NOOOOOOOOOOOO.