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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-17 : 19:49:05
|
Gopalakrishnan writes "hi,
Basically my question has 2 parts. These are the following 2 questions:
1. How can I add XML support (as in SQL Server 2000) in SQL Server 7? Is there any add-ons available?
2. How can I transpose the result of a SELECT statement? For example, if I run a query as "SELECT * FROM EMP", it would give me the column names as headings and values in rows (horizontally)as
eno ename
--------------------------------
1 ABC
2 XYZ
But, I want the result to be as
eno 1 2
ename ABC XYZ
Can I be able to do this through the Query itself?
Those are my questions. Thanks for you spending time for me. You can mail me the answers to the above mail ID itself.
Thanks,
N.T.GOPALAKRISHNAN" |
|
|
|
|
|
XML Support on SQL Server 7 and Transposing the result of a query