select [Transactions], Date, substring([Dimensionsspalten], 1,P1.Pos-1) AS BestellNr, substring([Dimensionsspalten], P1.Pos + 1, P2.Pos – P1.Pos – 1) AS Campaign, substring([Dimensionsspalten], P2.Pos + 1, P3.Pos – P2.Pos – 1) AS Channelgrouping, substring([Dimensionsspalten], P3.Pos + 1, P4.Pos – P3.Pos – 1) AS Source, substring([Dimensionsspalten], P4.Pos + 1, P5.Pos – P4.Pos – 1) AS Zeitstempel, substring([Dimensionsspalten],P5.Pos+1,LEN([Dimensionsspalten]) ) AS Medium […]

CREATE TABLE ZerlegenText (   id int, Inhalt nvarchar(255) )   INSERT INTO ZerlegenText SELECT 1,’TextA;TextB;TextC’   Zielview: 1 TextA 1 TextB 1 TextC   SELECT ID, Members.Member.value(‘.’,’VARCHAR(8000)’) Text FROM (–Convert delimited string to XML SELECT ID, CAST(‘<Inhalt><Text>’ + REPLACE(Inhalt, ‘;’ , ‘</Text><Text>’) + ‘</Text></Inhalt>’ AS XML) AS tempPlayer FROM ZerlegenText ) AS tempPlayer CROSS […]