Declare @Status int
select @Status = (case when datepart(dw,@date) in (1,7) then 1 else 0 end) --周末为1,平日为0if(@Status = 0)
select Table.* into #TempTable where Status in (1,2)if(@Status = 1)
select Table.* into #TempTable where Status in (3,4)报错:
数据库中已存在名为 '#TempTable' 的对象。请大家帮我修改下语句,达到我的预期目的
select @Status = (case when datepart(dw,@date) in (1,7) then 1 else 0 end) --周末为1,平日为0if(@Status = 0)
select Table.* into #TempTable where Status in (1,2)if(@Status = 1)
insert #Temptable select Table.* where Status in (3,4)
Declare @Status int
select @Status = (case when datepart(dw,@date) in (1,7) then 1 else 0 end) --周末为1,平日为0if(@Status = 0)
select Table.* into #TempTable where Status in (1,2)if(@Status = 1)
select Table.* into #TempTable where Status in (3,4)
drop table #temptable
select @Status = (case when datepart(dw,@date) in (1,7) then 1 else 0 end) --周末为1,平日为0if(@Status = 0)
select Table.* into #TempTable where Status in (1,2)if(@Status = 1)
insert #Temptable select Table.* where Status in (3,4)