–Created one Example table

create table Events

(

PeopleName varchar(50),

EventType varchar(50),

Events varchar(100)

)

 

–Model Values

insert into Events values(‘Daya’,‘B’,‘Drinking’)

insert into Events values(‘Daya’,‘B’,‘Washing’)

 

 

–Created function to take Events with Comma Seperated on EventType basis

CREATE FUNCTION dbo.MakeCommaValue (@pC2 AS VARCHAR(10))

RETURNS VARCHAR(8000)

AS

BEGIN

        DECLARE @oResult VARCHAR(8000)

         SELECT @oResult= COALESCE(@oResult+‘,’,”)+CAST(Events AS VARCHAR(10))

           FROM Events WITH (NOLOCK)

          WHERE EventType = @pC2

          ORDER BY Events

         RETURN @oResult

END

 

–Call the Function like this

SELECT DISTINCT

        PeopleName,EventType,dbo.MakeCommaValue(‘B’) as ‘Events’

   FROM Events

 

–Result

PeopleName   EventType        Events

—————————————

Daya          B                     Drinking,Washing