Thank you for the link.

I was able to make progress...

Sorry for the delayed response.

My inquiry can be disregarded the issue is with the underlying data.

Thanks again for chiming in, it's appreciated.

Well, I would I like to apologize if I was not clear in communicating my inquiry.

I have two different tables that consist of similar data elements. The paid amounts...

Excellent, this worked for me. Thank you for your help.

Thank you for your insight. Your example was not exactly what i needed to answer my question, mainly due to a new Id is issued for a readmission. I'm...

Thanks for the response. I'm still a bit confused. I'm trying to employ your CTE example, but I'm getting constant errors, mainly in the case statement. I know this is...

Thank you kind sir, you resolved my issue:)

Thanks for your input. So even if the data...

Anyone??????

Thanks for your insight fellas. The below example got me the result I was looking for.

Much appreciated!

Count(CASE WHEN visit_date Between '2/1/2016' AND '2/29/2016' THEN 1 ELSE 0 END)

Perry Whittle (2/1/2016)

Briceston (2/1/2016)

So I currently have a SSIS package that generates an excel output to my local and then copies that out excel output("PED.XLS") to a network shared folder....