转换前:
转换后
SELECT ID,CotegoryName,GoodsName,GoodsBrand,GoodsStandard,GoodsUnit,Price,Num,Money FROM(SELECT (ROW_NUMBER()OVER(ORDER BY GETDATE())-1)/9 RN,* FROM temp)T PIVOT(MAX(stringvalue)FOR name IN (ID,CotegoryName,GoodsName,GoodsBrand,GoodsStandard,GoodsUnit,Price,Num,Money))U