Viewing 2 posts - 1 through 2 (of 2 total)
finally i got the solution
select groupid from #temp group by groupid
Having Count(distinct clientcode) =
(
Select count(*) from
(select distinct clientcode from #temp) X
)
February 10, 2011 at 12:03 am
#1284961
Thanks Mark..
October 21, 2010 at 10:53 pm
#1240709