what drives me crazy about this error is that I don't think it's related to converting varchar to numeric as the error suggests.

I say this because I've been able to...

I haven't created a derived table. I'm not a pro at this so help me understand what A derived table would accomplish.

Are you saying I would insert all of the...

As I mentioned in my initial post, my company migrated from a SQL Server 2000 database to a SQL Server 2005 database.

Since this migration, I've had to fix all the...

Thanks Lynn. I appreciate your time and responses just as do the others that posted.

Amedeo

Sorry for the delayed reply. Report writing isn't my primary responsiblity so I'm limited on how much time I can spend on this.

I'm still leaning towards the fact that...

I think this error is mainly being caused by the convert() function within the first WHERE statement. As I originally stated, the query was working prior to the migration to...

The result_value and problem_code are both varchar datatypes.

I have not tried creating a derived table to filter the problem_code. I will try that and see what happens.

I tried using...

I actually had it listed as you suggested and removed the quotes around...

I didn't do exactly what you posted but your suggestion led me to figuring it out. I used the MAX() function in the SELECT statement and used a GROUP BY...

Donavon -

Thanks for your help!!!! I followed the suggestion of the link you posted and modified my query to include "ALL". I then set the default parameter for Doctors...

I will look at the article you suggested but what I find odd is that the default value for parameter 1 (billing status) works just fine. Parameter 2 (doctor) doesn't....

Thanks for the advice but that won't work for me. The reason being that my two parameters are billing status and doctor name. I set up two queries that return...

Thanks Thuan! Your solution solved my problem!