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 |
|
Onamuji
Aged Yak Warrior
504 Posts |
 Posted - 2002-01-25 : 18:18:44
|
| I have one function that returns the following: - account - cost center - line item - amount I have another function that I want to pivot the above function results on the cost center... the code is fine I believe.. what I expect is the following: - account - line item - sec201 - sec202 - sec203 Where sec### is the pivot result of the cost center... now running the select statement outside the function it returns all is well but it I try to use the function that does the pivot i get no results returned .. :-( is there something about functions being able to use other table functions that i'm not aware of ?- Onamuji |
|
|
Onamuji
Aged Yak Warrior
504 Posts |
Posted - 2002-01-25 : 18:23:02
|
| Never mind i'm brain dead at 6pm ... i had my parameters swapped :-( this is what coding for 32 hours is like huh ...- Onamuji |
 |
|
|
|
|
|
Pivot table VIA Functions