Hi Folks,

I need a help, to indentify duplicate records and associated counts from the child tables.

Here the script below

=======================================================================

IF OBJECT_ID('#CUS_TEMP','U') IS NOT NULL ...

Thanks Ramesh...

Its works fine... as per your suggestion.... And I will use right forum in future..:w00t:.

No ramesh....

I tried both above options... it does give the required output...

And morever I am using MS ACCESS.... Hence, I guess it doesn't take WHEN condition....

Help still needed.....