Selecting Row As Column - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Selecting Row As Column

Author

Topic

samamun001
Starting Member

17 Posts

Posted - 2005-05-03 : 02:42:16

Hi there. I have a table like

BonusNumber Name Amount
1 x 100
2 y 100
3 x 200

I want my output like this

x 100 200
y 100

Is it possible ? Plz help me

samamun

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-05-03 : 03:35:17

Refer this
http://www.sqlteam.com/item.asp?ItemID=2368

Madhivanan

Failing to plan is Planning to fail

rrb
SQLTeam Poet Laureate

1479 Posts

Posted - 2005-05-03 : 03:49:23

Or even better - without cursors

--
I hope that when I die someone will say of me "That guy sure owed me a lot of money"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources