I submitted my last reply without adding that...the data that I provided was just a small sample...

When I do an ORDER BY ASPECT_ID..I would see multiple rows for the same...

Here is the results from Sushila's request - 'salvatore - could you pl. query the 3 tables with the date filter...

(ACW.AUDIT_DTE BETWEEN '07/10/05' AND '07/14/05') (CWID.ADHERENCE_DTE BETWEEN '07/10/05' AND '07/14/05')...

I think that I am finnaly seeing some light at the end of the tunnel...after makeing some slight adjustments to the code, I have been successful in seeing 1 row...

Here is where I think the problem lies, and let me knowe if you agree..

The code that Sushila provided was sucessful, once I adjusted the JOIN to include the LTRIM...

Based on the suggessted code from Sushila I made a slight adjustment based on my tables:

SELECT CWID.ASPECT_ID, QPP.AGENT_NAME, AVG(ACW.[ACW %]) AS ACWPct, AVG(ACW.[ATT in sec.]) AS...

I can not say enough in appreciation for both Farrell and Sushila's support and suggestions...

To answer your questions, I am not sure which date field to use for the range???...and...

I have been away for a week, and now I am back, and trying to resolve this SQL issue...

My last attempt was to include the SELECT DISTINCT into the code...that...

OK...I was able to recreate my problem with the sample data that sushila provided me....

Below is the code, please try it and you will see what I mean:

CREATE TABLE #ACW_SCORE(...

I made the neccessary changes to the code, yet I am still geting the same results...

Below is the T-SQL code that I am using as well as the results:

CREATE VIEW...

Below is the T-SQL that I am using based on the suggestion from Farrel:

SELECT dbo.ACW_SCORE.ASPECT_ID, QUALITY_PASS_PERCENT.AGENT_NAME, dbo.ACW_SCORE.[ACW %], dbo.ACW_SCORE.[ATT in sec.],

...

I ran the new table data within the Query Analyzer, and the results I received were PERFECT!

The problem is placing that T-SQL code within the view that I am creating...In...

My last entry was supposed to have said that when I removed the date fields from the 3 views that I was querying, I receive accurate results...the following is a...

I placed the T-SQL into my view, and the output is still showing just 1 agent id...I noticed this was also the case when I placed Farrel's code within the...

I used the code that Farrell provided, and the results seem to be ok...the only thing that I am not sure is, that the view that has the EVALUATION_DTE field,...

I used the code that Farrell provided, and the results seem to be ok...the only thing that I am not sure is, that the view that has the EVALUATION_DTE field,...