Search results for query: *

Markros Thank you very much the index was the issue the Query went from over 2 minutes to 1 second :)!

Thanks for the Suggestion Markros I tried The Union ALL and it did not make any difference in speed. How would I implement the join Condition?

Thanks to EVERYONE you guys are great. I have a working query now and It runs pretty Quickly, However I had to add another field from another table "Dictations" after adding this inner join so I can get "DOS" the query runs VERY slowly. Can you tell me if there is a better way to do this SELECT...

Thanks to everyone, as you can tell I am pretty novice in the advanced query area. I would indeed be interested in a better way to construct this query. I think it would help me better understand the best way to handle this type of situation in the future. Thanks Rob

I have the following Query in which there is a Subquery However I don't know how to supply the values to my parameter values from my outer Query nor am I sure I can do this The subquery pulls in 5 values A1-A5 to the dataset but I am not sure how to feed the values for @Dictid and @Pid to the...