• liam.stirling (9/23/2008)


    I thought "The following statements are equivalent" meant they were the same.

    Silly me!

    Exactly. Even though the resultsets might be slightly different, the statements are equivalent. Boooo, I want my point back! 🙂

    Also does this highlight an issue with floating point anomaly in grouping sets, or has this always been an issue with aggregate statements on floating points, ie a SQL Server bug?