Wooohooo! I got a SQL server error that I have never seen before:
Internal Query Processor Error: The Query Processor Ran Out Of Stack Space During Query Optimization.
I am working on an old report for a client that originally had a small set of data and now has an ENOURMOUS set of data. Looks like it's time to start breaking a query up into smaller queries - give the SQL server less to worry about.