sql server - sum Comma seperated value from a column
- by Aseem Gautam
There is a column in database which contains comma seperated values like: 0.00,12.45,14.33 and so on.
I need to sum this inside a stored procedure. One way which I can think of is to split and convert it into a table using a function and then sum it.
Any other ideas?