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 |
|
werhardt
Constraint Violating Yak Guru
270 Posts |
 Posted - 2009-07-08 : 14:37:42
|
| I just upgraded to SQL 2008. Do you happened to know where the pivot function is on this. I have this select query below and I am having problems creating it.It needs to be grouped by Department. Thanks!SELECT DISTINCTOU,Domain,FullName,Title,Department,Company,Email,Phone,Mobile,FaxFrom PhoneDirectory |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-08 : 14:43:14
|
| show your sample output. we dont know what field you need to pivot on |
 |
|
|
|
|
|
Pivot Function