Thanks...and yes it is a bunch of records with insert into...select from..

Cool, I'll try to use the temp table approach to find it out...

many thanks

Cheers

Thanks a lot for the input....just a small additional question...why the division by 13 ??

HAVING COUNT(DISTINCT [Transaction]) = ' +

CAST((LEN(@instr)-LEN(REPLACE(@instr,'[Transaction]','')))/13 as varchar)

John

Venkat, the ouput should for the above example be:

ID

--

1

Since the ID=1 is the only ID that matches both my transaction types (1000 and 2000)....Note that the filter for the transaction...

Thanks for the answer..I just realized I missed to give some input...I want to dynamically build up the Where clause, that is  - in the end I want to put...