I get the following results when I run the script I posted so I'm not sure
how your environment differs:

Id LOC AGENCY BATCH
----------- ---- ----------- -----
7 I 1030 RRR
6 R 1030 RRR
8 V 1030 RRR

--
Hope this helps.

Dan Guzman
SQL Server MVP

"bala" <balkiir@gmail.com> wrote in message
news:1110368212.091319.272270@l41g2000cwc.googlegr oups.com...
> hi dan
>
> thanx for the response. i did try with 'WHERE NOT EXISTS' but didn't
> return any row. i am stumped now
>
> thanx buddy
> bala
>