• I couldn't agree more.

    Sometimes the analyst gives me some unformatted SQL code generated by a Build Query editor in SSIS.

    The first thing I do is format the whole thing. While I do this, I read the code which helps to understand it better.

    All my code is neatly formatted. This is extremely useful for debugging and maintenance, but also when you are explaining your code to someone else.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP