We need to create a unique ID, more like a line number, and similar to the manner in which MS Access creates an ID when you import files.

We have scripts (cursors) that create occurence numbers, but these rely on there being a date somewhere.

Does anyone have a method for creating this unique ID / Line number?

Many thanks in advance

John

You can have a column of type UniqueIdentifier and then use a default of NewId() or you can have an int column as a primary key with the IDENTITY property set.

--

Joe (Microsoft MVP - XML)