I have a stored procedure which turn data of database table into a string and stored in a temporary table's column, there is other column also in temp table.
Now I have to split that string & display in view table.
for example this is db table
name | age | class
john | 12 | 7
joe | 15 | 10
sp create a temp table
sl.no | string
1 | john~12~7
2 | joe~15~10
now I want to display in view table
name | age
john | 12
joe | 15