DECLARE @center_JZHW VARCHAR(500)

SET @center_JZHW = ( SELECT DISTINCT STUFF(

    ( SELECT  ',' + ce_code FROM ap_center WITH ( NOLOCK )

      WHERE   CE_PROVINCE = '浙江省' ORDER BY ce_code

      FOR XML PATH('')), 1, 1, '') AS jzhw

    FROM   ap_center t)

SELECT @center_JZHW

DECLARE @ret VARCHAR(200)

        SET @ret = ''

        SELECT  @ret = @ret + '|' + RTRIM(RT_GSX_COMPTIA_CODE)

        FROM    dbo.AP_REQUEST_RETURN_PART

        WHERE   rt_so_no = @so_no

        SET @ret = CASE WHEN LEN(@ret) > 0 THEN STUFF(@ret, 1, 1, '')

                        ELSE @ret

                   END

        RETURN @ret 

SELECT DISTINCT STUFF(

    ( SELECT  ',' + rt_loan_part FROM dbo.AP_REQUEST_RETURN_PART WHERE rt_so_no='IPTH14060001'

      FOR XML PATH('')), 1, 1, '') AS part

    ,STUFF(

    ( SELECT  ',' + RT_GSX_COMPTIA_CODE FROM dbo.AP_REQUEST_RETURN_PART WHERE rt_so_no='IPTH14060001'

      FOR XML PATH('')), 1, 1, '') AS COMPTIA_CODE

    FROM   AP_REQUEST_RETURN_PART t