Anyone here?

Just to add. Error is in this line.

SET @strColumnList = left(@strColumnList,len(@strColumnList)-1).

I tried differently but could not get the result I wanted. like.

SET @strColumnList = LEFT(@strColumnList, CHARINDEX(' ', @strColumnList) - 1)

SET @strColumnList = LEFT(@strColumnList, NULLIF(CHARINDEX(' ', @strColumnList) - 1, -1))