specifically you asked like " you want this logic in looping concept" , thats why i have implemented that way, otherwise i would have tried in the efficient way...

use the loop and insert into new table . Check with following code

declare @temp varchar(100)

select @temp ='ABC$$$DEF$EF'

select * from SplitDelimited ((replace(replace(replace(@temp,'$$$','-'),'$$','-'),'$','-')),'-')

if you want split methode , you can use...

3 Consective Period loop will go back. Please check the following code. if any other logic is available Please let me know.

[Code="sql"]

DROP TABLE #ClaCases

CREATE TABLE #ClaCases (ClaCaseID INT,ReceiverID int,...