support 86837 (12/18/2012)
Your query works only if I omit the HAVING clause.
What error are you getting? You're getting untested code as I don't have a sample set to work from for your particular issue. If you check the first link in my signature, you'll see how we usually ask for code assistance requests like this to be setup so we can get you tested code.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA