Seleccion con multiples campos coincidentes

[Andres95]

No veo que pueda estar mal, a lo mejor no te entendi bien...
te anexo un ejemplo de lo que entendi

Código:

If object_id('tempdb..#tmpCadena') is not null drop table #tmpCadena
create table #tmpCadena(cve1 int, cve2 int, dato char(1))

insert into #tmpCadena values(1,2,'A' )
insert into #tmpCadena values(1,2,'B')

insert into #tmpCadena values(1,3,'C')
insert into #tmpCadena values(1,4,'D')

insert into #tmpCadena values(1,5,'E')
insert into #tmpCadena values(1,5,'F')


Select c.* 
From #tmpCadena C 
inner join 
(select cve1, cve2 
from #tmpCadena
group by
cve1, cve2 
having count(1) > 1) M
On c.cve1 = M.cve1 And
   c.cve2 = M.cve2 



Resultado:

cve1        cve2        dato 
----------- ----------- ---- 
1           2           A
1           2           B
1           5           E
1           5           F