I have a very large SQL script that Crystal Reports XI is using to query my db. Unfortunately I'm getting an error (see this thread: http://www.experts-exchange.com/Database/Reporting_/Crystal_Reports/Q_22733281.html
I've spent a fair chunk of time systematically taking the query apart (after copying it from CR XI using Database --> Show SQL Query and pasting it right into a new SQL 2005 query window). But, no matter whether it was the original hugantic query, or any of a series of progressively simpler ones -- down to where it is now a simple SELECT statement with 15 columns from 1 table -- all of them are simply not executing. That is, SQL Server 2005 is simply (and continuously) parsing the query with no result. It's like it's caught in some infinite loop, although that certainly isn't the case here.
If there were anything wrong with my queries, it would take but a split second to return some kind of an error code at least...