• Christian Buettner-167247 (6/24/2013)


    More important - if you use regular tables instead, the query works just fine.

    Hmmm, that's a surprise to me! I thought you'd get the same problem when using permanent tables. So there is, apparently, much more to this than I first though.

    Thanks for putting me straight! 😉


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/