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 |
|
MattieBala69
Starting Member
30 Posts |
 Posted - 2005-09-29 : 10:15:34
|
| Hey , Lets say i have a table A which looks like thisName Month Year hoursChuck Nov 4 160Chuck Dec 4 80Chuck Jan 5 90Chuck Apr 5 45Kelly Nov 4 80Kelly Dec 4 80Kelly Jan 5 60Kelly Feb 5 35Don Jan 5 30Don Feb 5 25Don Mar 5 25Don Apr 5 25What i need is this is where i am lost . I have no idea how to make the data of one particular field in TABLE A to become field name in the select statement. The output should look like thisName 04-Nov 04-Dec 05-Jan 05-Feb 05-Mar 05-AprChuck 160 80 90 45Kelly 80 80 60 35 Don 30 25 25 25GTotal 240 160 180 60 25 70Thank you,Mattie |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Field Name