Splitting commas in a string
                            
                         
                        
                     
                 
                
                    Hi,
i want to know if i give some value like this:
select * from split('11,12|13,15|16,18')
i should get the output as
Id  Value1  Value2
1  11  12
2  13  15
3  16  18
please help me ,how to do this in sql server 2005
Thanks in advance