Split multiple columns into single column by delimiter?
split multiple columns into single column by delimiter?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
srinivas PPosted Sep 5, 2011, 5:43 AM
Name
Address
Srini vasa rao
103 guntur kothapet
Naresh babu
Ongole pandaripuram
Chenna reddy
Narasarao pet
I want to show following way from above two tables ,separated by delimeter 'space'
srini
vasa
rao
naresh
babu
Chenna
reddy
103
guntur
kothapet
Ongole
pandaripuram
Narasarao
pet
The above task will do in sqlserver
srinivas PPosted Sep 5, 2011, 5:42 AM
Name
Address
Srini vasa rao
103 guntur kothapet
Naresh babu
Ongole pandaripuram
Chenna reddy
Narasarao pet
I want to show following way from above two tables ,separated by delimeter 'space'
srini
vasa
rao
naresh
babu
Chenna
reddy
103
guntur
kothapet
Ongole
pandaripuram
Narasarao
pet
The above task will do in sqlserver
Posted Sep 5, 2011, 5:18 AM
Amit ChoudharyPosted Sep 5, 2011, 5:14 AM