sqlserver自定义函数多行查询记录合并成一列(实测通过）

USE xxy_test
GO
SELECT  dbo.F_HEBING_CHAQUE('2020-10-28', 'G02', 'PG') 

CREATE FUNCTION F_HEBING_CHAQUE
    (
      @pln_date VARCHAR(10) ,
      @lines VARCHAR(20) ,
      @cpdl VARCHAR(20)
    )
RETURNS NVARCHAR(2000)
AS
    BEGIN
        DECLARE @CHAQUE NVARCHAR(MAX);
        SET @CHAQUE = ( SELECT  D.ITEMNAME + ' '
                                + CONVERT(VARCHAR(50), CONVERT(INT, D.QTY_PLAN
                                - ISNULL(QTY_STOCK, 0))) + ','
                        FROM    T_PRD_PPBOMENTRYDTL AS D
                                INNER JOIN t_prd_dtl AS H ON H.FENTRYID = D.FENTRYID
                        WHERE   H.pln_date = @pln_date
                                AND H.lines = @lines
                                AND H.cpdl = @cpdl
                                AND D.QTY_PLAN > ISNULL(QTY_STOCK, 0)
                      FOR
                        XML PATH('')
                      );
                           
        RETURN LEFT(@CHAQUE,LEN(@CHAQUE)-1);
    END;
 GO