SQL que me traiga los registros que se repiten

[michael_045]

Tal vez el siguiente codigo te sirva para lo k necesitas
-------------------------
create proc sps_detalle
as
declare @numorden int
,@cadena varchar(1000)
select
numorden
,@cadena detalle
into #tmp
from
detalle
group by
numorden
declare cur_ cursor for
select
numorden
from
#tmp
open cur_
fetch next from cur_ into @numorden
while (@@fetch_status=0)
begin
set @cadena='|'
select
@cadena=@cadena + descrip + '|'
from
detalle
where
numorden=@numorden
print @cadena
update #tmp set detalle=@cadena where numorden=@numorden

fetch next from cur_ into @numorden
end
close cur_
deallocate cur_

select * from #tmp
-----------------------

Espero k no sea muy tarde.

Salu2.

Enjoy life... is the best we can do