• Lynn Pettis - Monday, December 11, 2017 10:03 AM

    I still use two part names, habit.  Plus, what happens when the one table query becomes a multi-table query?  I'd rather have the aliases already in place.

    I do too.
    But SQL Prompt fills them in automatically, if required, when moving from 1 table to 2 or more, so it's no extra effort.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.