For example:

In the first result below, there are three transactions with userid C205167665, C205170740, CU05166287 and there is no matching transactions in the second result. so we cannot update these...

Sorry actually you are right. I forgot one important detail.

here is exactly what I do.

first I run this query:

select *

from AGS_Hands_InProcess nolock

where WIn is NULL -- unfinished games

and ts_started<dateadd(hh,-1,getdate()) --...

Thanks. I confirmed with my boss and he said it cannot be done as you suggest.

So any other suggestion to the original question?

Lowell (11/12/2012)

---

ok, let me twist the question...