JimS-Indy (4/30/2013)
Kevin, the table build scripts for these four tables are probably 200 lines long, containing columns and foreign keys that are not relevant, and may be confidential. I know that what you wanted to do was recreate the structure and code an answer. For that, I'm grateful, but the last time I posted all that information, everyone stopped reading the post because it was so big.Thanks again.
Which indicates that the problem is too big/complex for a forum post anyway. Many people don't seem to realize (or care) that forums are for short, mostly-simple, targeted stuff with answers provided by volunteers. 🙂
BTW, hope you don't have either a) Cartesians or b) null values or you won't get the answers you expect out of your query. :hehe:
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service