mssql »ñÈ¡Êý¾ÝÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

--½¨±ísql
SQL code:

create database test
--±í1
create table tb1
(
tId int,
tTime datetime primary key(tId,tTime),
tWaterLevel decimal --ˮλ
)
--±í2
create table model
(
m_tId int,
m_wwl decimal,--¾¯½äˮλ
m_ewl decimal,--±£Ö¤Ë®Î»
)

insert into tb1(tId,tTime,tWaterLevel)
select 1,'2010-4-14 8:09:20',2
union all
select 1,'2010-4-14 18:09:20',2
union all
select 2,'2010-4-14 18:49:20',3
union all
select 3,'2010-4-14 18:49:20',4

insert into model(m_tId,m_wwl,m_ewl)
select 1,1,0.8
union all
select 2,2,1.8
union all
select 3,5,3



--Êý¾ÝÏÔʾ
SQL code:

--Êý¾ÝÏÔʾ
½ñÈÕ°ËʱˮÇé ×îÐÂË®Çé
±àºÅid ˮλ ±È¾¯½äˮλ ±È±£Ö¤Ë®Î» ˮλ ʱ¼ä ±È¾¯½äˮλ ±È±£Ö¤Ë®Î»
1 2 1 1.2 2 2010-4-14 18:09:20 1 1.2
2 ...
3 ...

½ñÈÕ°Ëʱ£ºtTimeʱ¼äÔÚ£¨8:00-8:15¶¼Ëã½ñÈÕ°Ëʱ£©
±È¾¯½ä/±£Ö¤Ë®Î»£ºtWaterLevel-m_wwl, tWaterLevel-m_ewl

---

ÒýÓÃ

--½¨±ísql

SQL code

create database test
--±í1
create table tb1
(
tId int,
tTime datetime primary key(tId,tTime),
tWaterLevel decimal --Ë