i see... I got your point...

I will create a trigger for update. This trigger will determined if the record was picked by a certain client, then the updation will be...

Thnks! Any idea what this may cause for approximately 2M rows? 🙂

WOW! Vladan your query is a little bit faster. I got a new query style for both of you guys. Both of your solution are good... But i will try...

hehehehe.. same guy...

anyway its been a headache for me...

Thanks for the help. I greatly appreciated.

1- Which columns make your PK? (Or, what is the purpose of the id column?

column id is the PK.

2- Why do different supplier_id's share one order_id? (see records 3...

ohhhhhhhh im very sorry....

lets make (matchID 3) from '2007-08-02 11:18:11.967' to

2007-08-02 12:18:11.967' to correct the result.

Im very sorry vladan for the datas...

yup... because the corresponding matching from tbltransaction happens only base on the top occurrences from TBLforMatching so in this case (matchID 3) will have no match.

thanks.

Yup sorry Vladan, i added just one(1). because desired result is wrong. tnx for the reply.