IDX MyText 1 Header1 2 BodyA 3 BodyB 4 Header2 5 BodyC 6 BodyD 7 BodyE 8 Header3 9 BodyF 10 BodyG 11 BodyH
IDX MyHeader MyText 2 Header1 BodyA 3 Header1 BodyB 5 Header2 BodyC 6 Header2 BodyD 7 Header2 BodyE 9 Header3 BodyF 10 Header3 BodyG 11 Header3 BodyH
SELECT IDX, MyText AS MyHeader INTO #Temp1 FROM MyTable WHERE LEFT(MyText, 7) = 'History' SELECT P.IDX , (SELECT TOP(1) T.IDX, T.MyHeader FROM #Temp1 T WHERE T.IDX < P.IDX ORDER BY T.IDX DESC) AS MyHeader , P.MyText FROM MyTable P WHERE LEFT(P.MyText, 7) <> 'History'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)