SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table t (date date, a int, b int, c int, d int);
insert into t values
('2010-11-16 10:02:00.000',  10,  null, null, null),
('2010-09-21 00:00:00.000',  86,    14, null,   17),
('2010-07-27 00:00:00.000', 125,    12, null,   11),
('2010-05-29 15:24:00.000', null, null, 1250, null);
4 rows affected

with cte as (
    select date
         , a, max(case when a is not null then date end) over () as date_a
         , b, max(case when b is not null then date end) over () as date_b
         , c, max(case when c is not null then date end) over () as date_c
         , d, max(case when d is not null then date end) over () as date_d
    from t
)
select max(date) as date
     , min(case when date = date_a then a end) as a
     , min(case when date = date_b then b end) as b
     , min(case when date = date_c then c end) as c
     , min(case when date = date_d then d end) as d
from cte


date
a
b
c
d


2010-11-16
10
14
1250
17


Warning: Null value is eliminated by an aggregate or other SET operation.


with cte as (
    select max(case when a is not null then date end) as date_a
         , max(case when b is not null then date end) as date_b
         , max(case when c is not null then date end) as date_c
         , max(case when d is not null then date end) as date_d
    from t
)
select max(date) as date
     , min(case when date = date_a then a end) as a
     , min(case when date = date_b then b end) as b
     , min(case when date = date_c then c end) as c
     , min(case when date = date_d then d end) as d
from t
cross join cte


date
a
b
c
d


2010-11-16
10
14
1250
17


Warning: Null value is eliminated by an aggregate or other SET operation.