SQL server 存储过程中 列传行

 

      select @exchange=exchange,@coupons_type=coupons_type
      from (

　　　 select exchange_id,coupons_type as coupons_type_points,

      exchange=(stuff((select ','+ convert(varchar,(0- FLOOR(exchange))) 
      from points_exchange_svc where exchange_id=@exchangeId
      for xml path('')),1,1,'')),

      coupons_type=(stuff((select ','+coupons_type 
      from points_exchange_svc where exchange_id=@exchangeId 
      for xml path('')),1,1,''))

      from points_exchange_svc 
　　　 group by exchange_id,coupons_type
      )  A

      where A.exchange_id=@exchangeId
      and A.coupons_type_points=@coupon_type

 

之前好像写过 SQL SERVER  xml  path 的知识 这次又用到了 当是复习吧