Thx for the reply Matt

Well, maybe I'm not explaining the data I'm working with very well...it is quite messy (crap in crap out?). Still, it should be do-able.

As for the...

Thx for your replies.

Glad to see I was using the correct examples....Union and not exists doesn't work and here's why...

The first query works on ProductCode (AA001, YY999)

The second query works...

It's ok...I've worked it out.

Insert into MyTable1 (MyDiscount,MyProduct) Select @discount,Product from MyTable2

I've posted over in the SQL 2000 forum.

Basically it looks like a hung proc. I've restared SQL and everything is hunky dory.

Thx

As an update

SPID 59 would not finish, and therefore neither would SPID 9

I restarted SQLServer services and they were gone. I then removed the AutoShrink option

Thx for the help.

Billy

Nice one

Thx very much. I'll keep that in mind.

Thanks Kenneth

As far as Autoshrink goes, could you elaborate (if you have time) why it's a bad idea?

Thx

Apologies...this belongs in the 7,2000 forum (which I thought I had selected....

It's ok.

I worked it out.

For anyone else having the problem, I simply highlighted the database saying (loading) and selected Restore Database and selected the same backup file used previously and...