Unique Record Numbers

[bob120579]

I have a request for a file that contains a field for a record identifier. This field must be unique per record per file. Now to assign this number I obviously can't create a regular query, and I am thinking a cursor is the best way to go to access each record one at a time. I am thinking of defining a variable and incrementing the count per record, and then setting the field to the variable. What is the best way to set this cursor up?

 

[jbenson001]

Use an identity column. You can seed and increment as you need. Check books on line.

Jim