Compressing multiple UNION ALL query

Dear Tom, The query below has be gnawing at me for a year. It works well but is so huge! (often the recordset it returns is larger than the query itself). So my question to you is: Q:Is it possible to write it in more compact form but <b>WI...

Read More...

---