--Grop by 语句
select ReYear,convert(char(2),ReMonth)+'月份小计',sum(ReOpenMoney),sum(ReceiveMoney)
,sum(RediffMoney),sum(ReTax)
from @ReTab group by ReYear,ReMonth
--case 语句
case isnull(@CustomerNo,'')
when ''
then CustomerNo
else @CustomerNo end