SQL Server 2017

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

CREATE TABLE TableX
(Id int,Path varchar(20));

INSERT INTO TableX 
VALUES
(1 , '2001/1/A'),
(2 , '2001/12/Bl'),
(3 , '2001/1/CkF');

SELECT *
FROM TableX;


Id
Path


1
2001/1/A

2
2001/12/Bl

3
2001/1/CkF


CREATE VIEW report 
AS SELECT Id,Path,
d.vals.value('(/TR/TD)[1]','VARCHAR(10)') AS 'year',
d.vals.value('(/TR/TD)[2]','VARCHAR(10)') AS 'month',
d.vals.value('(/TR/TD)[3]','VARCHAR(10)') AS 'com'
FROM (
SELECT Id,Path,
CAST('<TR><TD>' + REPLACE(Path, '/', '</TD><TD>') + '</TD></TR>' AS xml) vals
FROM TableX) AS d
SELECT *
FROM report


Id
Path
year
month
com


1
2001/1/A
2001
1
A

2
2001/12/Bl
2001
12
Bl

3
2001/1/CkF
2001
1
CkF