生肖计算

来源:互联网 发布:怎么在淘宝上同城购物 编辑:程序博客网 时间:2024/03/28 16:41

 create Procedure sp_GetSXPL
 @bettype int,
 @betver varchar(20)
as
begin
declare @nowyear int
create table ##tmpBet(bet varchar(10),betid int)
--create table ##tmpBet(bet varchar(10),betid int)
create table ##tempBetvalue(betImg varchar(1000),betid int)
set @nowyear=datepart(year,getdate())
declare @toyear int
set @toyear=1997
declare @x int
set @x=(@toyear-@nowyear)%12
set @x=(@x+12)%12
declare @y int
if @x<>2
set @y=(14-@x)%12
else
set @y=12
declare @i int
set @i=1
while @i<=49
begin
declare @tmpy int
declare @tmpBet varchar(100)
set @tmpBet= ''
if((14-((@i%12+1)-@y))%12=0)
set @tmpy=12
else
set @tmpy=(14-((@i%12+1)-@y))%12
insert into ##tmpBet(bet,betid) values(cast(@i as varchar),@tmpy)
set @i=@i+1
end
declare @k int
set @k =1
while @k<=12
begin
declare @tmpStr varchar(1000)
set @tmpStr=''
select @tmpStr=@tmpStr+','+'bet' from ##tmpBet where betid=@k
insert into ##tempBetvalue(betImg,betid) values(@tmpStr,@k)
set @k=@k+1
end
set @i=1
delete from ##tmpBet  --清除临时表中的记录
while @i<=49
begin
 insert into ##tmpBet(bet,betid) values(@i,@i%10+13)
 set @i=@i+1
end
set @k=13
while @k<=22
begin
--declare @tmpStr varchar(1000)
set @tmpStr=''
select @tmpStr=@tmpStr+','+bet   from ##tmpBet where betid=@k
insert into ##tempBetvalue(betImg,betid) values(@tmpStr,@k)
set @k=@k+1
end
drop table ##tempBetvalue
drop table ##tmpBet
end
go