todd.ayers (4/30/2013)
well..... Darn.. I dont have SQL on my desktop... only access 2007
Sorry, I can only guarantee that it will run in SQL Server 2008 - this is, after all, the SQL Server 2008 forum section ๐
Access will probably want to join it to a database down the network somewhere and plug on a front end with user toys. Be firm.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden