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 |
|
hdv212
Posting Yak Master
140 Posts |
 Posted - 2012-07-15 : 10:12:59
|
| Hii have a table which something like this :Tests(TestID int, Col1 money, Col2 nvarchar(50), Col3 int, RegsiterDate char(10))Now, i want to get pivot report based on the 'RegisterDate' column like this : 2012/01/05 2012/01/10 2012/01/15Col1 12.5 14.5 15.5Col2 Text1 Text2 Text3 Col3 5 6 7How can i do this ?thanks in advance |
|
|
|
|
|
How to generate this pivot report?