-- INIT database

CREATE TABLE Test (

  Entity varchar(100),

  Attribute1 VARCHAR(100),

  Attribute2 VARCHAR(100)

);

​

INSERT INTO Test(Entity, Attribute1, Attribute2) VALUES ('Entity A / Entity B', 'Something', 'Something 2');

INSERT INTO Test(Entity, Attribute1, Attribute2) VALUES ('Entity C / Entity D', 'Something else', 'Something else 2');

​

-- QUERY database

--SELECT * FROM Test;

SELECT v.value, t.Attribute1, t.Attribute2  FROM Test t 

cross apply string_split(Entity, '/') v;