CREATE TABLE TableA 
(
       [idx] [int] IDENTITY (1, 1) NOT NULL 
       ,[ITEM] VARCHAR(30)
       ,[ID] [int]
       ,[CODE] CHAR(10)
)
GO
 
INSERT INTO dbo.TableA(ITEM, ID, CODE)
SELECT '테스트품목1',584,'2068124292' UNION ALL
SELECT '테스트품목2',584,'2068124292' UNION ALL
SELECT '테스트품목3',584,'2068124292' UNION ALL
SELECT '테스트품목4',584,'2068124292' UNION ALL
SELECT '테스트품목5',584,'2068124292' UNION ALL
SELECT '테스트품목6',584,'2068124292' UNION ALL
SELECT '테스트품목7',584,'2068124292' UNION ALL
SELECT '테스트품목8',584,'2068124292'

GO


create function dbo.userTableA(@ID int)
returns varchar(8000)
as
begin
	      declare @rtnvalue varchar(8000)
	      
	      select @rtnvalue = coalesce(@rtnvalue+',','') + ITEM
	      from dbo.TableA
	      where ID = @ID
	      order by ITEM asc
	      
	      return @rtnvalue
end
GO

select dbo.userTableA(ID) as ITEM, ID, max(CODE) as CODE
from dbo.TableA
group by ID
order by ID asc