34,588
社区成员
发帖
与我相关
我的任务
分享
declare @赔率 numeric(18,10),
declare @游戏期号 int,
declare @表名1 varchar(10),
declare @表名2 varchar(10)
set @sqlstr='update '+ @表名2 +' set 获得金币=' + @表名2 + '.投注金币 * '+ @赔率 +' where 期号='+cast(@游戏期号 as varchar(10))
exec sp_executesql @sqlstr
set @sqlstr='update u set u.coin=u.coin + @表名2.获得金币,u.sorce=u.sorce
+
case when not EXISTS(select id from '+ cast(@表名1 as varchar(10)) +' where @表名1.uid=u.userid) then
case when getcoin - betcoin >=1000 and getcoin - betcoin<10000 then
1
when getcoin - betcoin >=10000 and getcoin - betcoin <50000 then
2
when getcoin - betcoin >=50000 then
3
else
0
end
else
0
end
,u.sorce2=u.sorce2+(
--此处还有一个case when....
)
from u inner join '+ cast(@表名2 as varchar(10)) +' on u.userid=@表名2.uid where @表名2.期号=' + cast(@游戏期号 as varchar(10))
exec sp_executesql @sqlstr