--> 测试数据：[test]
if object_id('[test]') is not null drop table [test]
create table [test]([date] datetime,[字段1] numeric(3,2),[字段2] numeric(3,2))
insert [test]
select '2012-05-03 02:00:00.000',0.28,1.00 union all
select '2012-05-03 05:00:00.000',0.28,1.10 union all
select '2012-05-03 08:00:00.000',2.22,8.00 union all
select '2012-05-03 11:00:00.000',0.83,3.00 union all
select '2012-05-03 14:00:00.000',1.11,4.00 union all
select '2012-05-03 17:00:00.000',2.50,9.00


go
declare @date datetime
set @date='2012-05-03 08:00:00.000'
;with t
as(
select * from [test] where [date]<=@date
union all
select dateadd(HH,1,a.[date]),ISNULL([字段1],0.28) [字段1],ISNULL([字段2],1.00) [字段2] from t a
where not exists(select * from [test] b
where b.[date]=DATEADD(HH,1,a.[date])
)
and a.[date]<@date
)
select *from t order by [date]

/*
date    字段1    字段2
2012-05-03 02:00:00.000    0.28    1.00
2012-05-03 03:00:00.000    0.28    1.00
2012-05-03 04:00:00.000    0.28    1.00
2012-05-03 05:00:00.000    0.28    1.10
2012-05-03 06:00:00.000    0.28    1.10
2012-05-03 07:00:00.000    0.28    1.10
2012-05-03 08:00:00.000    2.22    8.00
*/