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 |
|
genius_palli
Starting Member
42 Posts |
 Posted - 2008-12-04 : 05:58:14
|
| Hi everyone..I am trying to use PIVOT option with Common Table Expressions, but not able to execute the query. Can any one please suggest that whether i am in the wrong direction or missing something or what can be the cause of the error.Please suggest.. really urgent need to solve the problem.Thanks in advance for your suggestions.----------------------------------Every experience has something to learn. Go get it.Thanks and Regardsgenius_palliWeb Developer |
|
|
karthickbabu
Posting Yak Master
151 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
genius_palli
Starting Member
42 Posts |
Posted - 2008-12-04 : 06:57:39
|
| Thanks everyone for suggestions..I was not aware about :-its always required to use an aggregate function with pivot's column.----------------------------------Every experience has something to learn. Go get it.Thanks and Regardsgenius_palliWeb Developer |
 |
|
|
|
|
|
Common Table Expressions with PIVOT