Chris,

Thanks for that, I will modify it accordingly and give it a try.

Thanks again for your assitance.

brett

Chris,

I could do that, and possibly simplify my life quite a bit, I didn't know that I could do that. Can I import into a table with an...

Hi Chris,

The table with the SEQ_NUM as autoincrement is an existing table in the database that I am eventually trying to import into. The table that I am creating...

With help from my friend Google, I have managed to get the MAX + 1 part right by declaring it as a variable first. New script as follows;

BEGIN

DECLARE @n NUMERIC(10);

DECLARE...