CREATE TABLE T(CH1 INT,CH2 VARCHAR(10))
GO
INSERT INTO T VALUES(1,'abc')
INSERT INTO T VALUES(1,'def')
INSERT INTO T VALUES(2,'wer')
INSERT INTO T VALUES(2,'wqr')
GO
create function getstr(@ID int)
returns varchar(1000)
as
begin
declare @str varchar(1000)
set @str=''
select @str=@str+rtrim(CH2)+',' from T where CH1=@ID
return @str
end
GO
select CH1,dbo.getstr(CH1) from T GROUP BY CH1 HAVING COUNT(*)>1
go
DROP TABLE T