Due to how the network is set up, that isn't really an option.

I was thinking some kind of batch file which calls the stored procedure, therefore meaning any chanegs to...

I understand, in the real data it is date and time, so there should never be that situation 🙂

Peter

What do you mean regarding duplicate date values per column?

Is that with regard to a row with the same partno and same datetime entry?

Peter

Works Perfectly!

Many Thanks,

Peter

That's very helpful, using ther actual naems etc I now have the below:

insert into tbl_weighcalctemp select * from tbl_weigh where partno like 'FGL%' or partno like 'EGL%'

--

-- import into tbl_weighcalc,...

Thanks- I think I understand most of that.

I know the first bit is a sample data setup, so if I already have put the required rows into a temporary table,...

Sorry- You can tell I'm new to this whole thing!!

SQL Server 2000 8.00.760

Does this make it harder?

Peter

Well my login screen shows Windows Server 2003 enterprise manager, but as far as I am aware there was no server 2003 so this is actually based on server 2000?

Thanks,

Peter

Thanks, I've just given this a try and got an error that row_number() is not supported.

I had a look and have found that I actually have server 2000, any ideas?

Thanks for the quick reply- what is the first 'select * from (' for?