mssql2008 列转行语句

select JOB_ORDER_ID,   [CONTAINER_NO]=stuff((select ','+CONTAINER_NO+':{柜型:'   +(select ctn_type from SB_CTNDEF where DEF_NO = CONTAINER_SIZE_TYPE)+',体积:'+cast(GROSS_CUBE as varchar)+',重量:'+   cast(GROSS_WEIGHT as varchar)+'}' from OZ_BK_CONTAINER     where JOB_ORDER_ID=a.JOB_ORDER_ID  for xml path('')),1,1,'') from OZ_BK_CONTAINER a  where job_order_id = a.JOB_ORDER_ID  group by JOB_ORDER_ID select  USR_CODE , USR_NAME from SB_USER  select top 1   [USR_CODE]=stuff((select USR_CODE from SB_USER  for xml path('')),1,1,'') from SB_USER a