Thank you Sir.

I just gave it a run through and it works perfectly!

Cheers again!

Thanks for the replies Gentlemen.

I decided to go with a Passthrough query created in VBA so that I could pass the Dates (which is stored on the source table as...

Thanks Peter, unfortunatly it is not.

I have however discovered why it takes so long to run, and this is because it is running that code for EVERY record in the...

Thanks guys.

I went with the DTSRun option.

Its now failing on a seperate issue, complaining about the ODBC in the DTS package itself which is strange as other JOBS already...

THANK YOU Jeffrey, that worked like a charm !!

I had a feeling the syntax was awry somewhere.

Cheers!

Thanks Neal.

Never used SQL cursor before, but shall look into it.

Cory that is great.

Just ran it and it works perfectly, thank you so much!!

Cheers Lewis, that was spot on !!

Thanks again,

Mitch...

Hello again Lynn,

just want to apologize for...

Sure, sorry Lynn, i'm getting poked from all sides here today and i'm not able to get a minutes peace !

Hi Lynn,

the code I am using in SQL is below:

UPDATE DBO.tblTest

SET PV_OLD = tblTest_1.PV_NEW * POWER((1...

Hi Lynn,

well i'm rewriting a qry from Access to SQL.

The qry matches two fields to another instance...

Thank you Sir, much appreciated !!

It's a many to many relationship. Although there are duplicate Account numbers in table one and duplicate account numbers in table 2 there can only be one account number with...

Hi Lynn,

thanks for the reply and forgive my delay but things here have been swamped.

I ran your Select...