Home Forums Article Discussions Article Discussions by Author Discuss content posted by Carlo Romagnano "SELECT @local_variable" RE: "SELECT @local_variable"

  • June 25, 2010 at 9:23 am

    #1185083

    kevin.l.williams (6/25/2010)

    Hugo Kornelis (6/25/2010) Is 0.1% chance of incorrect results acceptable for your user?

    Not for me.

    Hugo, is this the article you were looking for?

    "The correct behavior for an aggregate concatenation query is undefined."

    http://support.microsoft.com/kb/q287515/

    EXACTLY!

    Thanks for locating it, Kevin. That was exactly the article I had in mind.

    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/