Thanks a lot for all your contributions

MysteryJimbo .. Best Solution 🙂

SSCrazy ..Thanks for help but applying normalization rules will be hard little bit in my situations

OK ..Thanks a lot "dwain.c" .. Yes your are right ..but that was just try to simplify my real script .. The Real Script has another columns order by ..But...

Yes ..sorry for that ..It shall be startIndex and EndIndex Paramaters

Like what am doing in the above script

Its Great .. I will use Function Solution Luis ..Thanks a lot for your help 🙂

Thanks a lot Luis .. Can I handle it without functions ?? is there any other alternative way ??

Thanks a lot Micky .. Less Code ..Amazing + Perfect +That is what i want (y)

https://www.simple-talk.com/sql/learn-sql-server/window-functions-in-sql-server/

Thanks Dwain

I think with that modification it can give me what I want

DECLARE @Temptbl TABLE( Neighborhood nvarchar(50),Governorate nvarchar(50),City nvarchar(50),Country nvarchar(50));

WITH SampleData AS (

SELECT ID=ROW_NUMBER()...