不过好像不是这个错误啊。。
select convert(varchar(10),inout_date,120),summary ,merchant_provider,card_patch ,sign_expired,sum( in_amount ) amount_in,sum( out_amount) amount_out , @store=@store+sum( in_amount ) -sum( out_amount) stroe
from #t
group by convert(varchar(10),inout_date,120),summary ,merchant_provider,card_patch ,sign_expired
还是一样的错误
select convert(varchar(10),inout_date,120),summary ,merchant_provider,card_patch ,sign_expired,sum( in_amount ) amount_in,sum( out_amount) amount_out , @store=@store+sum( in_amount ) -sum( out_amount) stroe
from #t
group by convert(varchar(10),inout_date,120),summary ,merchant_provider,card_patch ,sign_expired
还是一样的错误
select inout_date,summary ,merchant_provider,card_patch ,sign_expired,sum( in_amount ),sum( out_amount), @store=@store+sum( in_amount )-sum( out_amount)
from #t
group by inout_date,summary,merchant_provider,card_patch ,sign_expired