If you can do a select in the from statement for the patients that have 2 chgs/proc and use it as a driver to select the rest of the info.

Jim

"I have NEVER seen a GUI query designer that was good for developing queries with ANY level of complexity. They are at best handcuffs and much like wizards in that...

If I remember correctly, there was a prior QOD on this same subject. It's answer was that table variables and temp tables were always in memory until they got...

Great question.

Really made me think. Still got the question wrong, but I learned from it.

Agree with your standards. Never thought of indenting the FROM, WHERE etc by only two spaces. That would make "folding" in a text editor easier to use.

I would...