sqlserver 列进行分割转多行

直接上代码

 

  SELECT 
            c.value('.', 'varchar(50)') AS fassetNO,
			a.sbmc as fassetName,a.ggxh as funit,a.dw,a.sl,
			b.ywxqzz as forg,convert(char(10), getdate(), 120) as fbeginUseDate,a.wsje as foriginalCost,
			b.sgdw as fsupplierNO,b.FReqDepart as fdepartment
   FROM     formtable_main_526_dt1 a

            CROSS APPLY ( SELECT    CAST('<row>' + REPLACE([zcpm], ',',
                                                           '</row><row>')
                                    + '</row>' AS XML) AS xmlcode
                        ) C1 
            CROSS APPLY xmlcode.nodes('*') t ( c ) 
			
			   left join formtable_main_526 b on a.mainid=b.id
			where a.mainid=13 and a.gdzcpd=0;