| Topic : Vertical data to column data using sql server 2005 |
|
|
|
Activity:
Question posted: 04 13 2010 14:17:37 +0000,
2 answers, 909 views, last activity
07 06 2010 20:18:08 +0000
|
|
tblData Id Caption Value 1 Account 100023 2 Name XYZ 3 Balance 5000 I want to show this records in following manner Account Name Balance 100023 XYZ 50000
2 Answers for "How to show row data in column in sql server 2005?"
Prev1NextShowing 1 - 2 of 2
Answered by
prashant pamani, Project Leader -(Technical), Sunbelt Outsourcing Pvt Ltd
| 04 22 2010 13:41:27 +0000
Not Rated
Pivot is only use on numeric fields
Answered by
md majid akhter, Senior Software Engineer, Razorgator technology pvt ltd
| 04 22 2010 09:38:22 +0000
Not Rated
i hink you can use pivot and unpivot keyword of sql server 2005.
Prev1NextShowing 1 - 2 of 2
Found the question
"How to show row data in column in sql server 2005?"
interesting?
Refer to your connections and communities
Viewers also viewed
|
|
Dynamic Management Views The dynamic management views (DMV’s) in SQL Server 2005 are designed... |
|
|
11 referals
6 comments,
1828 views
|
|
|
I am associate of prajapati association and i am working for BJP from year 2005 to till date.... |
|
|
0 referals
3 arguments,
111 views
|
|
|
reality shows are killing talents, the sms polls and popular choice are exploiting talented... |
|
|
55 referals
10 arguments,
392 views
|
|
|
|
|
|
|
Unanswered Questions (65)
|
|
IS ACADEMIC PERCENTAGE CRITERIA ALWAYS MANDATORY FOR EXPERIENCED SAP CONSULTANTS. HOW TO OVER... |
|
|
1 referals
0 answers,
0 views
|
|
|
Helo rohit, i am Hemant from Kanpur UP,going to take admission in mca for 212 batch at cgc... |
|
|
1 referals
0 answers,
0 views
|
|
|
|
0 referals
0 answers,
0 views
|
|
|
|
|
Sponsored Jobs
More From Author
Quality is the Absence of Problems Something doesn’t cause me any problems, and I have no complaints about it, it doesn’t get in the way of work or play, it’s always held up, never breaks, never dies, it’s “Old Reliable” – that’s a sure sign of... |