|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Generate data entry and reporting .NET Web apps in minutes, straight from your database. Read our FREE whitepaper “Build Web 2.0 Applications Without Hand-Coding” Download now! |
|
#1
April 28th, 2004, 06:59 PM
|
|||
|
|||
|
How do I do a cross tabulation in SQL 2000
I'm trying to create a table that has different products as the columns and the rows are represented by customers. The table is populated with sales by produt and customer. I'm trying to tabulate the totals across by customers and down by products so that the far right column will have the total saled by per customer and the last row will have the totals per product. Then the last column last row will have the over all total sales. I'm new to SQL so any help will be appreciated.
|
|
#2
April 29th, 2004, 03:00 AM
|
||||
|
||||
|
You can adapt to MsSQL this great article or use MsAnalysis Services, take a look at www.databasejournal.com for many good tutorials.
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > How do I do a cross tabulation in SQL 2000 |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
