SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table t (client_id int, status int, start_date date, end_date date);
insert into t (client_id, status, start_date, end_date) values
  (1, 1, '2022-01-01', '2022-01-02'),
  (1, 1, '2022-01-03', '2022-01-04'),
  (1, 1, '2022-01-12', '2022-01-15'),
  (2, 1, '2022-01-03', '2022-01-03'),
  (2, 1, '2022-01-05', '2022-01-06');
5 rows affected

select
  max(client_id) as client_id,
  max(status) as status,
  min(start_date) as start_date,
  max(end_date) as end_date
from (
  select *, sum(i) over(partition by client_id order by start_date) as g
  from (
    select *,
      case when dateadd(day, -1, start_date) <> 
        lag(end_date) over(partition by client_id order by start_date) 
      then 1 else 0 end as i
    from t
  ) x
) y
group by client_id, g
order by client_id, g


client_id
status
start_date
end_date


1
1
2022-01-01
2022-01-04

1
1
2022-01-12
2022-01-15

2
1
2022-01-03
2022-01-03

2
1
2022-01-05
2022-01-06

client_id	status	start_date	end_date
1	1	2022-01-01	2022-01-04
1	1	2022-01-12	2022-01-15
2	1	2022-01-03	2022-01-03
2	1	2022-01-05	2022-01-06