i have only one coloumn in a table i want to dispaly all the datas in a row.Name of the table is student which contains only one coloumns slno
Student
Slno
1
2
3
4
5
I want to display them as
slno 1 2 3 4 5

Thanks in advance
Raju

Member Avatar for Geek-Master

Take a look at the PIVOT command in Books Online.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.