The application is a supplier evaluation application which uses question sets to evaluate suppliers and calculates weak, strong areas etc.
One of the reports which I need to do is take from the categories and provide how many points where scored from the question table 
by putting them in subcategories.

It is very complicated and I am really battling to get this right, it seems as though there is a common key between each table. But I can 
calculate scores etc and return them into a specific result set. I would also like to post a screen dump of how the report should look if possible.

I have a categories table as follows:

CREATE TABLE [dbo].[seCategories](
	[CategoryID] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
	[CategoryName] [nvarchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Description] [nvarchar](200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[MaxScores] [numeric](18, 0) NULL,
 CONSTRAINT [PK_seCategories] PRIMARY KEY CLUSTERED 
(
	[CategoryID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]



I have a SubCategories table as follows:


CREATE TABLE [dbo].[seSubCategories](
	[SubCategoryID] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
	[SubCatNumber] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[SubCatName] [nvarchar](150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Description] [nvarchar](1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[CategoryID] [numeric](18, 0) NULL,
	[NumQuestions] [numeric](18, 0) NULL,
	[PercentageQuestions] [float] NULL,
	[MaxScore] [float] NULL,
	[DefaultPerform] [float] NULL,
 CONSTRAINT [PK_seSubCategories] PRIMARY KEY CLUSTERED 
(
	[SubCategoryID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]



I have a questions table as follows:



CREATE TABLE [dbo].[seQuestions](
	[QuestionID] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
	[Description] [nvarchar](1000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[QuestionType] [numeric](18, 0) NULL,
	[Number] [numeric](18, 0) NULL,
	[SubCatID] [numeric](18, 0) NULL,
	[QSet] [numeric](18, 0) NULL,
	[DepartmentID] [numeric](18, 0) NULL,
 CONSTRAINT [PK_seQuestions] PRIMARY KEY CLUSTERED 
(
	[QuestionID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]



I have a Evaluation Detail table as follows:

[code]

CREATE TABLE [dbo].[seEvaluationDetail](
	[EvalDetailID] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
	[ProcessID] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[QuestionID] [numeric](18, 0) NULL,
	[Score] [float] NULL,
	[AssesmentValue] [float] NULL,
	[EvalGroup] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
 CONSTRAINT [PK_seEvaluationDetail] PRIMARY KEY CLUSTERED 
(
	[EvalDetailID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]