sqlserver 2008支持行合并语法

--SELECT distinct VMX.ITEMS_ID, VMX.FAID, VMX.ITEM_PARAID, VMX.REMARK,
VMX.LOG_USERID, VMX.LOG_DATE, VMX.ITEM_PARAID AS ITEM_PARAID_NAME,
                      VMX.LOG_USERID AS LOG_USERNAME, KMMC_STR=STUFF((
SELECT ','+KMMC_STR FROM VI_XCGL_CS_COSTITEMS
 WHERE ITEMS_ID=VMX.ITEMS_ID FOR XML PATH('')),1,1,''
 )
FROM
VI_XCGL_CS_COSTITEMS VMX