统计 sqlServer grouping with Rollup

select 

case grouping( CONVERT(VARCHAR(20),CONVERT(DECIMAL(20,0),SSP.SeatTicketTypePrice)))
when 0 then CONVERT(VARCHAR(20),CONVERT(DECIMAL(20,0),SSP.SeatTicketTypePrice))
when 1 then  '总计'
end as 'XX',
COUNT(O.orderId ) '单数',SUM(O.ticketCount) '张数' 
 from [Order]  O
inner join [OrderElec] oe on O.orderId =oe.OrderId  and oe.PrintType>0
inner join [SessionSeatPriceType] SSP on SSP.SeatTicketTypeSessionId=O.sessionId and O.orderSellPriceType=SSP.seatTicketTypePriceID
where O.sessionid =XX 
and O.orderType=XX
and O.orderMode=XX
and O.orderVisable=XX
and O.orderPayment=XX
group by  CONVERT(VARCHAR(20),CONVERT(DECIMAL(20,0),SSP.SeatTicketTypePrice))  with Rollup