In my prior job I was know for my willingness to create very advanced
TSQL queries. I have written queries exceeding 10,000 characters
in length without any WHERE clause. I know this because we stored
the queries in a database table which had a VARCHAR(8000) column, and I
had to change it to be TEXT. The same query had CASE statements
embedded three deep and derived tables embedded three deep, but it was
because I need to flatted data in ways the data structure never was
intended to.
Now I'm writing simple financial reports (Income Statements, Trial
Balances, etc.) and, due to the fact we're using Data Dynamics' Active
Reports,...