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 |
|
kid_on_the_block
Posting Yak Master
172 Posts |
 Posted - 2006-02-22 : 03:27:59
|
| The following is my table structure :- Emp IDJan-AcJan-Ac-PJan-AbsJan-EfJan-Ef-PFeb-AcFeb-Ac-PFeb-AbsFeb-EfFeb-Ef-PMAR-AcMar-Ac-PMAR-AbsMAR-EfMar-Ef-P....I want to have a view that would be Emp_CodePointsJan FebMarApril....e.g. of the outputEmp_Code Points Jan Feb Mar April----------------------------------------------------001 AC 10 20 30 40001 AC-P 20 30 40 50001 Abs 10 20 50 60So its just vertical of what it was horizontal beforePlease help !!!!!! |
|
|
Norwich
Posting Yak Master
158 Posts |
Posted - 2006-02-22 : 05:46:19
|
| Check out this link:[url]http://www.sqlteam.com/item.asp?ItemID=2955[/url]RegardsNThe revolution won't be televised! |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Query