笑看天下

摘要： declare @strSQL varchar(8000)declare @week decimal(18,0)declare @week1 decimal(18,0)set @week=(select week fromaaaa where date=convert(varchar(10),getdate(),112))set @week1=@week-1set @strSQL=''set @strSQL=@strSQL+'if object_id(''tempdb..#a'') is not null drop table #a cr 阅读全文