34,590
社区成员
发帖
与我相关
我的任务
分享
用存储过程来实现
declare proc p
@start int,
@id int
@dfid int
as
declare @pmoney int
select top 1 @pmoney from 手续费表 where @start<手续费 order by 手续费
update 账户表 set 钱=钱+@start where id=@id
update 账户表 set 钱=钱=@start-@pmoney where id=@dfid
select
手续费=
case
when 转出行='建行' and 金额<=10000 then 3,
when 转出行='建行' and 金额>10000 and 金额<=30000 then 5 end
from 转账表
select
bank1,
bank2
Amount,
(case when Amount<=10000 then 3 when Amount<=30000 then 5 end) as 手续费
from 交易