SQL gurus, I have a query I need help with. This is not your run of the mill select/join/union query so I'm looking for a hired gun. If it matters, the server is SQL 2005. If you are a highly skilled querier, send and email to channing dot sql at channingc.com. Channing