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)
 Crosstab query help

Author  Topic 

keyursoni85
Posting Yak Master

233 Posts

Posted - 2009-05-15 : 03:19:36
hi all
i have to display columns as row wise and that rows in columns...

e g
FieldVal FieldName
--------------------------------
naitik FirstName
shah LastName
testcomp Company
stpt Address

output should like..
FirstName LastName Company Address
naitk shah testcomp stpt

..
thanks in advance

robvolk
Most Valuable Yak

15732 Posts

Posted - 2009-05-15 : 06:59:40
Please do not cross post:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=125761
Go to Top of Page
   

- Advertisement -