I don't think I use Union All enough in my procs...

I subscribe to many of the KBAlertz feeds, one of which is for SQL Server.  Sometimes the titles of these things just demand you take a look at them.

“FIX: A stack overflow exception may occur, and SQL Server 2000 may unexpectedly close when you submit a query that uses the UNION ALL operator more than 255 times”

I’m not positive, but I think this code has a future on the Daily WTF.