Hi,

I found a solution but i dont know if its the best performance wise.

Note :dbo.COM_FN_SplitString : it splits a string based on the delimiter passed

/*****Code*****/

Declare @table1 as table(rowID int IDENTITY(1,1),GroupId...