So, in my case, I have no choice but to call the vendor a dope and move on. I think I'm going to call the vendor and get a quote...

Thanx. I don't think we're being served very well....................

Just to be clear................if the USE tells the procedure which db to go to AND I want the procedure to go to TEST instead of PROD, then I would need...

Thanx. So, if I were to copy a db and rename it from PROD to TEST, the sp's would run the same way on TEST without any code changes? Unless...

Thanx. This is what I'm looking for.

See above comment. If you get some records that only have one of the codes, this shows that the query isn't what I want.

I'm looking for records that have both 305.1 and 491. These would be people that are smokers and have COPD.

Thanx for your help and the articles.

I got it now. I needed to exclude WeekOfMonthNumber and ArrivedVisits out of the group by.

I still get the zeros with MAX. Here's the whole insert.........

insert into VISITS(provider, fiscal_month, month_name, WeekNumberOfMonth, ArrivedVisits) values('ABELES M.D.,DEBORAH',1,'October',1,12)

insert into VISITS(provider, fiscal_month, month_name, WeekNumberOfMonth, ArrivedVisits) values('ABELES M.D.,DEBORAH',1,'October',2,15)

insert into VISITS(provider, fiscal_month,...

Simply genious. Thanx.

Problem 1.

I would like to be able to put in a date range that spans several months but, in order to simplify this, I'm limiting the date range to...

Can I have another hint? I'm at the end of my rope trying to get this.

Thanx.

Pardon my ignorance but, what does the % 7 do in the DATEADD(day, 6 - DATEDIFF(day, 6, ApptDt2) % 7, ApptDt2)?

Also, I read the articles about cross tabs. Very slick....