This is just an extract of the original tables, this is only to show you the table design and with only those fields those I requre in my queries.

I don't...

Count of patients who got vaccinated is not all that I want. It needs to be filtered with certain criterias.

Thats why I have also attached the criteria in word file.

is there any other way to write this query to improve efficiency? As the indexes are not the issue our database is very much evolved.

Here is the table...

Hi,

I have attached an actual execution plan. It might not be as relevant because I am not working on Live environment as I have just wrote this query and...

@SSchasing

I have attached the updated document which describes what I am looking for.

This what I want to compile from the database:

The percentage of children 2 years of age who had...

I am just asking for suggestions, I never expect someone to rebuild muy query.

U made a nice indentation of the code. I like it, I used to do the same but that will put most of my code out of visible area of...

This is a query for one of our Hospital client needs to submit Clinical measure report required by CDC. I have attached a word document which describes the Criteria for...

Using long list of this codes in query will make it dificult for me to read the query. That is wjhey I am generating a temporary table 'tempMU' to look...