I apologize for my ignorance, but I am a bit confused as to what I should do with the DDL and sample data that you provided...

Am I to replace my...

The results should be 1 record for each ID, this should be taken care of within the JOIN...the problem is that the output gets messed up when a date is...

Ok...here you go:

ACW_SCORE:

AUDIT_DTE____ASPECT_ID___ACW %____ATT in sec.

6/1/05_________6142_______6.4________201.8

6/27/05________6426_______0__________212.3

7/7/05_________7609_______4.3________242.4

COMPLIANCE_WITH_ID:

ASPECT_ID_______Average Compliance %_____ADHERENCE_DTE

__0303_________________94_________________7/27/05

__5732_________________97_________________7/20/05

__7609_________________85_________________7/7/05

QUALITY_PASS_PERCENT:

AGENT_NAME______Total Scores___Average Score__Total Passes___Pass %_HSCID_EVALUATION_DTE

Alexander, Antuan_____1____________87_____________1___________100___7609_7/7/05 5:40:02 PM

Alexander, Antuan_____1____________87_____________1___________100___7609_7/7/05 5:53:28 PM

Alexander, Antuan_____1____________87_____________1___________100___7609_7/14/05 12:38:56 AM

Allison, Katy_________1____________85_____________1___________100___6001_7/15/05 1:11:34 AM

Does the above help? I placed...

I agree...I am in the process of providing the details...

This is what I have so far...please bear with me, I am still learning how to provide DDL and DML for...

You know...it is those little things that will drive you to drink!

Wait....I am all reeedy drinkkkng...

THANKS!!!

Thank you for your reply...but it still giving me an answer of '1'...Mathematically when I divide 1 by 40 I should have a decimal of .025, which when translated into...

Thank you all for your assistance on this one...

I was able to sucessfully group by the Employee_NME, by adjusting the way the statement is written...

Select

[Employee Name] = EMPLOYEE_NME,

[Follow-up...

Sorry Remi...

Here you go:

CURDATE | EMPLOYEE_NME | MANAGER_ID | ACTION_TAKEN

6/22/05 4:43:40 PM | Flintstone,Fred | 30000002 | Follow-up

6/22/05 4:32:40 PM | Flintstone,Fred | 30000002 | Warm Transfer

6/22/05 4:43:40 AM |...

Thank you for responding....below is what I am getting from the SQL statment I provided:

The column names are:

Employee Name | Follow-Up | Warm Transfer |

Here is the...

Is my issue related to how my SQL statement is constructed??

Or is it something else??

If anyone can assist me, that would be great!

Remi,

Thank you so much for your help...it works great, and I learned some things too!

I made the adjustment for the date...but my output still summing the individual question by test...when I really need is the sum for the incorrect questions for the dates...

So I...

OK, so I ran that statement in the Query Analyzer, and I saw the output...now it is summing up the incorrect answers by question for each test...but what I need...

I apologize..for the sample data...it did not look like that when I placed it in the reply...

Let me know if you need more clarification.

Thank you

Ok here is my fields:

TEST_DATE QUESTION1 QUESTION1_SCORE QUESTION2 QUESTION2_SCORE

4/25/05 B 1 ...