--MSSQL 버전이없네요~ 2000을기준으로하겠습니다.

 

create table test(F1 char(1),F2 int)

 

insert test

select 'a',1 union all

select 'a',2 union all

select 'b',3 union all

select 'b',4 union all

select 'b',5 union all

select 'b',6 union all

select 'c',7 union all

select 'e',8

 

go

 

------------------------------------------

-- create function

 

create function get_string(@F1 char(1))

returns varchar(200)

as

  begin

   declare @ret varchar(200)

   select @ret = coalesce(@ret + ', ' + convert(varchar,F2) ,convert(varchar,F2))

      from test

   where F1 = @F1

   return @ret

  end

 

------------------------------------------

select distinct F1, dbo.get_string(F1) F2

   from test

 

/*

F1   F2

---- -----------------------------

a    1, 2

b    3, 4, 5, 6

c    7

e    8

 

(4개행적용됨)

*/