How can i show data with semicolon delimited in a column into multiple rows?
I have a table like below.
Id NAME --- ------ 1 A;B;C 2 D;E
I want get the data as below
Id Name --- ----- 1 A 1 B 1 C 2 D 2 E
Can any one help me on this?
Thanks in Advance Ashok
No comments:
Post a Comment