--
```sql
declare @BeginDate datetime
declare @EndDate datetime

declare @water1 float
declare @water2 float

declare @gpsIndex nvarchar(50)

set @BeginDate = '2018-08-27 00:00:00.000'
set @EndDate = '2018-08-27 18:59:59.997'
set @water1 = 2.16
set @water2 = 1.07

```
while(@BeginDate < @EndDate) begin
```sql
set @gpsIndex =convert(nvarchar(50),convert(bigint, datediff(ss, '1970-01-01 00:00:00', @BeginDate))*1000 + datepart(ms,@BeginDate))

insert into [ZHDMTProj].[dbo].[库水位1] ([GPSIndex],[aDatetime],[X])
```
values(@gpsIndex, @BeginDate, @water1)
```sql
insert into [ZHDMTProj].[dbo].[库水位2] ([GPSIndex],[aDatetime],[X])
```
values(@gpsIndex, @BeginDate, @water2)

--
```sql
set @BeginDate=DATEADD(MINUTE,1,@BeginDate)
```
end