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 12:06 pm

    #1185179

    Ninja's_RGR'us (6/25/2010)

    Hugo Kornelis (6/25/2010)

    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.

    I guess someone forgot to read my post :hehe:

    I did read your post, but the Connect item you linked to was not what I meant when I wrote that I knew this to be documented by MS. The MSKB article Kevin found was.

    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/