SELECT AVG(A),AVG(B)... ,GETDATE() INTO #T FROM TB WHERE TIME BETWEEN ..AND
insert into ta (字段一、字段二.....) select avg(字段一),avg(字段二),... from ta where time between '2010-02-01' and'2010-03-01'
Use test GO --首先保证你的第一个表中有时间字段 Create table SoureTable ( col0 int identity(1,1) primary key clustered, col1 datetime,--数据产生的时间 col2 float,--第一条数据 col3 float -- .... ) --第二个表 Create table DesTable( clo0 int identity(1,1) primary key clustered, clo1 float, clo2 float, clo3 float --... )
--存储过程 GO Create Procedure ColAvg( @StartTime datetime, @EndTime datetime ) AS begin insert into DesTable select AVG(col1),AVG(col2),AVG(col3) from SoureTable where col1 between @StartTime and @EndTime end GO
declare @begin_time datetime,@end_time datetime,@show_time datetime set @begin_time=... set @end_time=... set @show_time=... select avg(column1),avg(column2),avg(column3),@show_time into _newtable from table where time between @begin_time and @end _time
insert into ta (字段一、字段二.....)
select avg(字段一),avg(字段二),... from ta
where time between '2010-02-01' and'2010-03-01'
GO
--首先保证你的第一个表中有时间字段
Create table SoureTable ( col0 int identity(1,1) primary key clustered,
col1 datetime,--数据产生的时间
col2 float,--第一条数据
col3 float
-- ....
)
--第二个表
Create table DesTable( clo0 int identity(1,1) primary key clustered,
clo1 float,
clo2 float,
clo3 float
--...
)
--存储过程
GO
Create Procedure ColAvg( @StartTime datetime,
@EndTime datetime
)
AS
begin
insert into DesTable select AVG(col1),AVG(col2),AVG(col3) from SoureTable where col1 between @StartTime and @EndTime
end
GO
declare @begin_time datetime,@end_time datetime,@show_time datetime
set @begin_time=...
set @end_time=...
set @show_time=...
select avg(column1),avg(column2),avg(column3),@show_time
into _newtable
from table
where time between @begin_time and @end _time