Hi

I want to retreive duplicates

table

report_id   sched_id    ID13                   ID14                ID15      

61      1458    COUNTRYWIDE    SUPER EAGLE   NO
61      1478    CAPITOL                   SUPER EAGLE   NO
61      1450    COUNTRYWIDE    SUPER EAGLE   NO

now sched_id 1458 and 1450 is duplicate

my query is

select id12,id13,id14,id15,report_id,count(sched_id) as cnt
from #tmp group by id12,id13,id14,id15,report_id

i want my output to be

report_id   sched_id    ID13                   ID14                ID15
61      1458    COUNTRYWIDE    SUPER EAGLE   NO
61      1450    COUNTRYWIDE    SUPER EAGLE   NO

please help me to solve this.

thank you

Please, don't post multiple messages (even if it's urgent).
I've responded to your other thread, here:
http://groups.google.com/group/microsoft.public.sqlserver.programming...

Razvan

-----------------------------------------------Reply-----------------------------------------------