Hi,
Or you can try:
create table #test
(
[Key] int,
[value] varchar(10)
)
insert into #test values
(1,null),
(2,null),
(3,null),
(4,'A'),
(5,null),
(6,null),
(7,null),
(8,'B'),
(9,null),
(10,null),
(11,null),
(12,null),
(13,null),
(14,'C')
;with cte as(
select t1.[Key],t2.[value],ROW_NUMBER()Over(Partition By t1.[Key] Order By t2.[Value]) as rn
from #test t1
join (
select *
from #test
where value is not null ) t2
on t1.[Key]<=t2.[Key] )
select [Key],[Value]
from cte
where rn=1
Thanks,
Xi Jin.
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to
MSDN Support, feel free to contact MSDNFSF@microsoft.com.
