Since this sat around a bit here, I'll ask the obvious. Can you post the DDL and a few rows of sample data here, specifically for the Map table? I assume numbers is simply a Tally table.
- Craig Farrell
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