Thanks again Ramesh and William. Sorry, for the delayed update 🙂

Ramesh, your query fit correctly after tweaking the NEW_TERMS and OLD_TERMS conditions.

William, NEW_TERMS and OLD_TERMS is fine but no_trx condition...

Thanks Ramesh and Willem. I will update you tomorrow after running this query.

Thanks Willem for the query.

The problem really comes, if any terminal does both '051' and '021' transaction, it will reflect in both old and new terminals.

But if any transactions...

Thanks Ramesh. The query looks fine. I just tweaked the data and the results are not correct. 🙁 Please check with this data.

SELECT 'Feb 6 2010 12:06PM','12600004 ...

Thanks Ramesh.

1. I forgot to add 801 in new type. 051 / 801 is new type

2. If there is a transaction with 021, it should be there in old terms...

Just curios: Is SQL agent startup is manual or auto start?

Thanks Nabha and Lutz.

Nabha, The solution looks for all rows in T1 (even, if there no trx in Trx1 table)

Thank you Jeff for the query. You saved my time. Thanks again.

Did you try this to get sa account?

http://support.microsoft.com/kb/322336

Thanks all. Lutz, this is what i want. thanks. Parthi, i think, the solution is bit complicated for a simple select. thanks .

Thank you all.

Many scripts available in SSC. please search for it.

you may try this

http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31929/

Thank you all for the suggestion and link.

Thanks dave. There is another link. I just overlooked it. Thanks again.

Thank you Dave. This is what i need. I also need this solution to work with SQL 2000. Is there any way?

Thanks