Home Forums SQL Server 2017 SQL Server 2017 - Development Find a string with two dots RE: Find a string with two dots

  • January 2, 2018 at 11:30 am

    #1974111

    ChrisM@Work - Tuesday, January 2, 2018 10:16 AM

    -- SQL Server will perform the filter and the conversion in either order

    -- Note that Compute Scalar is plonked anywhere convenient in the execution plan

    -- and may not relate to where it actually occurs, as here.

    It was my understanding that the query follows the execution plan, so the Compute Scalar determines exactly where it actually occurs.  I think you meant that it may not be where it logically occurs.

    Drew

    J. Drew Allen
    Business Intelligence Analyst
    Philadelphia, PA