I have a table with the following structure.  There is a unique ID for
each column:

Unique_ID   Grade1   Grade2   Grade3   Grade4
1                  A+          A           B            A
2                 C             A+        C            D
etc.

Basically, there are rows of grades per unique ID.

I need to create a summary table based on the first table.  For each
grade, I want a count of each A+ grade, each A grade, each B grade,
etc

For example:

Grade_Name   A+    A    B   C    D
Grade1           1       0    0    1    0
Grade2           1       1    0    0    0

I've tried many things and am a little confused!  Any help would be
appreciated!

Thanks,
AS

Basically you need to unpivot the table first to a normalized form and then
to pivot to the summary that you need. Here is one way to do this:

-- Unpivot with a view
CREATE VIEW GradesNorm (Grade_Name, Grade)
AS
SELECT 'Grade1', Grade1 FROM Grades
UNION ALL
SELECT 'Grade2', Grade2 FROM Grades
UNION ALL
SELECT 'Grade3', Grade3 FROM Grades
UNION ALL
SELECT 'Grade4', Grade4 FROM Grades
GO

-- Pivot to summarize
SELECT Grade_Name,
           SUM(CASE WHEN Grade = 'A+' Then 1 ELSE 0 END) AS 'A+',
           SUM(CASE WHEN Grade = 'A' Then 1 ELSE 0 END) AS 'A',
           SUM(CASE WHEN Grade = 'B' Then 1 ELSE 0 END) AS 'B',
           SUM(CASE WHEN Grade = 'C' Then 1 ELSE 0 END) AS 'C',
           SUM(CASE WHEN Grade = 'D' Then 1 ELSE 0 END) AS 'D'
FROM GradesNorm
GROUP BY Grade_Name

If you are on SQL Server 2005 you can look up UNPIVOT and PIVOT.

HTH,

Plamen Ratchev
http://www.SQLStudio.com

-----------------------------------------------Reply-----------------------------------------------