Hello Everybody,
Can anyone tell me how to create a pivot table in SQL Server?
I am attaching a picture of what the table should look like before and after the transformation. Thank you in advance.This is an FAQ.
This is handled in SQL 2005, but not in 2000 or 7.0. There are a couple of 3rd-party tools that create pivot-table-like structures. Look for RAC4SQL and SQL Crosstab.
Regards,
hmscott
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment