Need Sql query

[rdssiva]

Table Stru

ID Name
1 A
2 B
3 C
4 D

Want to display in Out put

Names
A b C D

E F G H

like

tell me the query

[debasisdas]

what have you tried so far ?

[rdssiva]

what have you tried so far ?

nothing i don't know how to start..plz help me

[ck9663]

Use PIVOT/UNPIVOT.

If it's a simple straight forward long string delimited by a comma or semi-colon, read this.

Happy Coding!!!

~~ CK