splitting commas in a string
If i give a value like this
'11,12|13,14|15,16'
I want to remove that ',' and '|' and i need my output as follows:
id value1 value2
1 11 12
2 13 14
3 15 16
I want to achieve this by inserting values in temporary table and by using charindex in sql server
thanks in advance