Intersting SQL Query

SELECT @unique_key = (SELECT keyvalue FROM XXXXXXX)

Well, Any person with basic SQL knowledge would be able to say what it means, but would also be annoyed to know that this type of the queries are quite common and very easily visible in some of the SQL code in many financial production systems.

Are you surprised at what you see ? Well, if your are planning to move from west to east coast, and are being put into some existing system, be ready to see this type of code.. This is just a sample and be ready for any thing which is of similar quality and worse than this for other languages too.

Having worked in some of the big financial firms, this is not very surprising, and quite frustating to work on any of these older systems, specially when people sitting on those products are not willing to either enhance the product quality or even share the information about the product functionality. I am involved in one such mess, although first in financial world.

Let's see how far can I sail through this mess, and make some improvements to the system or refactor or create new systems for replacing existing systems.

Wish Me Luck!!!