• I picked no because of the COUNT_BIG requirement, but also because it is not known if ANSI_NULLS and QUOTED_IDENTIFIER were ON when the table was created. (and ANSI_NULLS when the view was created)

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