• Another vote for the view.

    The DSV has the tendency to hide things for you, while a view is more straightforward.

    Also, if the database is in source control it is more obvious to other people that a change took place and that it was the addition of a column.

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