Help with tabl

[Samand]

Hi,
I have a table that has 200 columns. I need to use a few of them to get some data for a report. In short part of the table looks like this:

Header 1	Header 2	Header 3	Header 4	Header 5
Pass	Fail	Minor	Pass	Fail
Fail	Pass	Pass	Fail	Pass
Minor	Pass	Fail	Pass	Minor

I need to get the following result:

	Pass	Fail	Minor
Header 1	count	count	count
Header 2	count	count	count
Header 3	count	count	count
Header 4	count	count	count
Header 5	count	count	count

Due to the amount of rows & columns and use of the report I can't use excess.

[alansidman]

Initial observation leads me to believe that you may have a normalization issue. Please look at the link below on how to design a rdbms. If you follow the rules of normalization you should be able to query your table with little or no issue.

http://www.deeptraining.com/litwin/d...aseDesign.aspx