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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-09-16 : 12:16:33
|
Mary writes "Microsoft Access has a wonderful utility for making crosstab queries (known as "Pivot tables" in the Excel world) that are useful for making graphs. Is there anyway to duplicate the "TRANSFORM" and "PIVOT" procedures done in Access in the SQL world? I've seen articles on this, but all of them assume that you know how many fields you'll need to create--none of them deal with creating fields dynamically. (I'm doing this in SQL Server 7.0 on two workstations--one with Windows NT 4.0/Service Pack 6 and the other with Windows 98 SE installed)."
|
|
|
|
|
|
Crosstab Query/Pivot Table