I usually have several separate sessions going and it's not always on for all ...strange !

Guys,

I casted just one of then just to give me dd/mm/yyyy

I used convert and style 103.

Thanks,

Eamon

Thanks PW !!!

You're cursor suspicions were correct.

It was the bottle neck in the process as I rewrote the logic using several updates.

THANKS !!!!!!!!

Guys, thanks for the help so far....the solution from addict (bottom of page 1)

Select A.Product_id, A.Purch_Date, B.*

From A

Inner Join B

On A.product_id = B.product_id

-- Join to derived table of...

i knew this was tricky.

the join has to exist to, yes, the most recent, but yes, recent as per the purchase date. we don't want to reference an edition of...

apologies, that reported error message was a typo !

but it still returns the wrong information.

basically i'm looking for the recent match.

also.....

a product may be purchased on say 5th Dec 2005

but the product's last profile update may be 23 Nov 2005.

just though i would add that in just in case.

Eamon

running this gives me

Server: Msg 147, Level 16, State 2, Line 1

An aggregate may not appear in the WHERE clause unless it is...

thanks guys !!

this all very very helpful

Eamon

Yes, its a VBSCript and it doesn't capture or report an error.

any help welcome,

Eamon

perfect !

Thanks alot Merrill,

Eamon

. worked !

I had the server registered as LOCALHOST, deleted and registered it again.

Thanks,

Eamon