SQL Server multiple row merge row

1. Using functions

Go

CREATE FUNCTION Dbo.fn_sumtype (@type varchar (50))
RETURNS varchar (8000)
As
BEGIN
DECLARE @values varchar (8000)
SET @values = ' '
SELECT @values = @values + ', ' + Product_type from [DataCopy2] WHERE [email protected]
RETURN STUFF (@values, 1, 1, ")
END
GO

The test is as follows:

SELECT customerfullname, data = Dbo.fn_sumtype (Customerfullname) from [DataCopy2] GROUP by Customerfullname

2. Using XML technology

Select Customerfullname, Data=stuff ((select ', ' +product_type from [DataCopy2] t WHERE customerfullname=t1. Customerfullname for XML PATH (")), 1, 1, ')
From [DataCopy2] T1
GROUP by Customerfullname

SQL Server multiple row merge row