Could you tell me why I am getting the following errors?

Msg 139, Level 15, State 1, Line 0

Cannot assign a default value to a local variable.

Msg 137, Level 15, State...

You find the number of active patients per month then, average those months. Remember, the number of active patients changes each month due to deaths, new patients, patients move out...

It returned nothing. I tried to tweak it a bit but, still couldn't get anything. I formatted the dates, if your willing to do some testing.

Thanx.

create table dbo.Visits

(

MRN varchar(8),

ApptDt datetime

)

insert...

Thanx. Sorry about the dates.

I'll give it a shot.

Thanx.

So, I understand that a where clause isn't required in a join but, my understanding of a join is "comparing" a column from one table with a column from another...

Thanx. Would it be wrong to place a where clause after,

"AND OE.Category = OMC.CategoryID"

and include all of those nested Selects in the where clause?

Thanx. The data is such that there will be only one value for those fields.

Thanks again for your help.

I'm such a rookie. So, assuming the code works now, the first patient, 100276, has two records with Ethnicity of ENGL and Ethnicity3 of ALBANIAN. I'd like the two records...

Wonderful. Thanx.

Then October, November and December would be 13, 14 and 15.

I wanted it to be more generic and not be tied to a table.

Thanx. Will do.

Thanx.

Thanx for the advice. How much work is it to set up a new server? We use VM here.