Query for Cloumn field as Rows

Emma Krystal · August 18th, 2011, 08:01 AM

Hi,

I want to display column values as rows... Can anyone give me sql query for this...

My table looks like this - :
SELECT pk_userId, user_name
FROM dbo.User_Table

2 emma
3 manoj
4 sneha
5 Ankita
6 enna

Now I want a query for this -

emma| manoj| sneha| Ankita| enna ==> thiese are column name
| | | |

planoie · August 19th, 2011, 09:26 AM

There really isn't any standard SQL to do this because it doesn't fit the set model of SQL tables.

This sounds to me like you have a problem with the way you are constructing your table. Why do you have columns for the users? You should have a table with columns like UserID & UserName, then a row for each user. Then getting the list of users becomes trivial:

Code:

SELECT * FROM user_table