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 2005 Forums
 Other SQL Server Topics (2005)
 Display row value as a TABLE column

Author  Topic 

smiley28
Starting Member

1 Post

Posted - 2011-02-08 : 15:21:06
Hi,

This is my current output:

acct_cd ticker
1234 abc
3453 xyz
5344 pqr

This is what i want to see:

acct_cd abc xyz pqr
1234 (calc) (calc) (calc)
3453 (calc) (calc) (calc)
5344 (calc) (calc) (calc)

Where 'Calc' is some calculation.

Any help would be much appreciated.

Thanks.

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-02-09 : 00:50:51
check out PIVOT operator in Books On Line

http://msdn.microsoft.com/en-us/library/ms177410.aspx


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -