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