Hello Michael,


This is a commerical product for school systems and my program will only be used at the beginning of the summer to move students schedules to the Career Center from the Home District. Each home district has it own nsuniq table that is unique to them. They also have a field called Ident that is unique to the whole system. I looked and the type for Ident is VARCHAR(10).

I am in way over my head but am keeping up thanks to UTC and the microsoft news server I am keeping up.

As always
Thank you very much
Jim

>You can use the UPDATE command to perform both operations:
>
>DECLARE @newid int
>
>UPDATE [Audat].[testcareercenter].[dbo].nsuniq
>SET @newid = iNextUnique, iNextUnique = iNextUnique + 1
>WHERE tablename = 'Studemo'
>
>Is there anyway that you can move the nsuniq table off the remote server? I'm worried about the performance.
>
>-Mike