Lowell does do a great job, but lemme ask you Cees... have you calculated the header or are you going to manually change it in the code?

That IS a good article... thanks, Ken.

Heh... You beat me to it! 

And, if you can't afford that kind of schooling for the company, at least read about change management and change control.  Use Access or...

Ummm.... wouldn't a CHECKSUM or BINARY_CHECKSUM at the row level be a little easier?

And, if you want to make sure it's a table...

IF Object_ID('tempdb..#fred','U') IS NOT NULL

What?  You got beer?

Heh... yeah... I've run into this a couple of times my own self... most of the time, I pummeled the vendor until they provided correct data.

When all hope was lost,...

And, people wonder why I didn't spend the money to go to PASS.  S²D² if you know what I mean

Sorry it worked out...

One of the easiest and fastest ways is to dump the query results into a temp table that has a "line ID" column that is an IDENTITY column... in ACCESS,...

Or, the OP could post the offending code, sans password, so we can actually try to troubleshoot the command for him

That was the key, Serqiy... thanks ol' friend.

Hey there, Greg!  You finally made it!  Welcome to the "mosh pit"

Heh... Thanks for the nice compliment, Chris...

First off and as a bit of a side bar... you don't need the BEGIN/COMMIT pair because the default settings for SQL Server are to treat each UPDATE as an...