I've just solved a problem and then realized it could serve as a great job interview question:
You have an auto-generated SQL select query with 1000 or so columns being selected. Each selected column uses a combination of functions. One of them uses a combination the SQL server cannot handle. The error message does not tell you which one. Describe a method to track down the trouble column in a reasonable amount of real time without modifying the query generating code or creating an automated tool. -- Sasha Pachev AskSasha Linux Consulting http://asksasha.com Fast Running Blog. http://fastrunningblog.com Run. Blog. Improve. Repeat. /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
