SQL Server 2017

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

CREATE TABLE mytable(
   Id        INTEGER  NOT NULL  
  ,Status    VARCHAR(8) NOT NULL
  ,StartDate DATE  NOT NULL
  ,EndDate   DATE  NOT NULL
);
INSERT INTO mytable(Id,Status,StartDate,EndDate) VALUES (1,'B','20190207','20190211');
INSERT INTO mytable(Id,Status,StartDate,EndDate) VALUES (1,'B','20190211','20190213');
INSERT INTO mytable(Id,Status,StartDate,EndDate) VALUES (1,'B','20190213','20190218');
INSERT INTO mytable(Id,Status,StartDate,EndDate) VALUES (1,'C','20190218','20190223');
INSERT INTO mytable(Id,Status,StartDate,EndDate) VALUES (1,'C','20190223','20190310');
INSERT INTO mytable(Id,Status,StartDate,EndDate) VALUES (1,'B','20190310','20190315');
INSERT INTO mytable(Id,Status,StartDate,EndDate) VALUES (1,'B','20190315','20190325');
INSERT INTO mytable(Id,Status,StartDate,EndDate) VALUES (1,'B','20190325','20190401');
INSERT INTO mytable(Id,Status,StartDate,EndDate) VALUES (2,'A','20190205','20190208');
INSERT INTO mytable(Id,Status,StartDate,EndDate) VALUES (2,'A','20190208','20190420');
INSERT INTO mytable(Id,Status,StartDate,EndDate) VALUES (2,'A','20190420','20190422');
INSERT INTO mytable(Id,Status,StartDate,EndDate) VALUES (2,'D','20190422','20190505');
INSERT INTO mytable(Id,Status,StartDate,EndDate) VALUES (2,'A','20190505','20190510');
INSERT INTO mytable(Id,Status,StartDate,EndDate) VALUES (2,'A','20190510','20190630');

14 rows affected

Id	Status	StartDate	EndDate
1	B	2019-02-07	2019-02-18
1	C	2019-02-18	2019-03-10
1	B	2019-03-10	2019-04-01
2	A	2019-02-05	2019-04-22
2	D	2019-04-22	2019-05-05
2	A	2019-05-05	2019-06-30