The proper thing to do now is post your resolution to...

Change the OR to an AND.

No, my typing is. The denominator for my calculations should have been 10 not 5. Nice catch!

If you need to do it in the query, does this do what you want?

SELECT

[tbl_IDS_Extract_Local-2].Customer_No,

MasterProductTable_Database.SFAProductCategory,

MasterProductTable_Database.ProductLevel,

...

Where is this query being used, a report, a front end app?

What I got from the version is that you are using the same base code. Your version of MSDE wasn't SQL Server 7.0 or (7.5). You still would...

Original snippet from your code:

(t.ItmRecvdYR1 - t.ItmRecvdYR2)/t.ItmRecvdYR1

This is integer arithmetic. ItmRecvdYR1 - ItmRecvdYR2 is less than ItmRecvdYR1, ie (10 - 5) / 5 = 0.

By multiplying one of...

Looks about right. All you have to do now is test it.

What do the execution plans for the updates show?

Try this in its place and let us know if it works:

SELECT

t.Loc + ' ' + upper(l.abbreviation)[Abbr],

t.VendorID,

DATEPART(YEAR,t.DateYR1)...

ALTER DATABASE. Look it up in BOL.

Before transfering the data, change the recovery model of your test database to use the simple recovery model.

Not sure what kind of script you are talking about. If there are any structure changes, SQL Server will handle that for you.

I'd check to see if another full backup was run between 02:00 and 06:00. Start by checking the msdb.dbo.backupset and msdb.dbo.backupfile tables.

Also, if the full backup actually was completed...

Just to be sure, post the actual code you used.