if exists (select * from dbo.sysobjects where id = object_id(N'#Temp_Month') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table #Temp_Month
CREATE TABLE #Temp_Month (
[date] datetime null,
[sum] int null,
[name] varchar(100) null
) ON [PRIMARY]
declare @Sql varchar(200)declare @indate datetime
set @indate=getdate()set @Sql='insert into #Temp_Month ([date],[sum],[name]) SELECT '''+convert(varchar,@indate,120)+''',SUM('+@name+'),'''+@name+''' FROM Cell '
set @Sql=@Sql+'where [date] <='''+convert(varchar,@indate,120)+''' AND [date] > DATEADD([day], - 15, '''+convert(varchar,@indate,120)+''')'exec (@Sql)
select * from #Temp_Month
drop table #Temp_Month
CREATE TABLE #Temp_Month (
[date] datetime null,
[sum] int null,
[name] varchar(100) null
) ON [PRIMARY]
declare @Sql varchar(200)declare @indate datetime
set @indate=getdate()set @Sql='insert into #Temp_Month ([date],[sum],[name]) SELECT '''+convert(varchar,@indate,120)+''',SUM('+@name+'),'''+@name+''' FROM Cell '
set @Sql=@Sql+'where [date] <='''+convert(varchar,@indate,120)+''' AND [date] > DATEADD([day], - 15, '''+convert(varchar,@indate,120)+''')'exec (@Sql)
select * from #Temp_Month
解决方案 »
- PL/SQL最差实践14例
- 将一个表中数据插到另一个表中出现问题 大家帮忙
- vb2008 如何检测指定Excel文件中特定名称的工作表是否存在
- 求助!用作业方式备份大数据库时报错
- 各位sq达人看看
- 循环查询出错了
- window XP 能否装SQL SERVER?能装什么版本的?
- 超过4GB内存的服务器SQLserver怎么用?(问题解决就结贴,在线等待)
- 一次insert多个记录时怎么写触发器?
- 连接局域网上另外一台机子上sql server2000的connectionstring是怎样的啊?
- 存储过程中的变量怎么那么短呀?!
- 请教一下,SQL怎么update 数据表的前1000条呀?谢谢.
drop table #Temp_Month
CREATE TABLE #Temp_Month (
[date] datetime null,
[sum] int null,
[name] varchar(100) null
) ON [PRIMARY]
declare @Sql Nvarchar(2000) --注意修改了定义declare @indate datetime
set @indate=getdate()set @Sql='insert into #Temp_Month ([date],[sum],[name]) SELECT @indate,SUM('+@name+'),'''+@name+''' FROM Cell '
set @Sql=@Sql+'where [date] <=@indate AND [date] > DATEADD([day], - 15,@indate)'exec sp_executesql @Sql,N'@indate datetime',@indate
select * from #Temp_Month