I have one table where there is two column loan no and counter_value.
Against each loan no there is the list of comma separated values are stored.
declare @tbl table (loanno varchar(100) , counter_value varchar(200) )
insert into @tbl
I need to do grouping according to loan no and in-position aggregation (summation) on counter values.
I need the output like below.