SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts by Clyde Merrell

SQLServerCentral.com profile

   Items 1 to 1 of 1   

Union Forcing Distinct

The use of union would seem to force a distinct in each of the select statements being unioned. The use multiple unions, with mixed union and union all clauses, seems to cause haphazard results.  Read more...
By Clyde Merrell 2013/05/14 | Source: SQLServerCentral.com | Category: union
Rating: |  Discuss |   Briefcase | 897 reads
   Items 1 to 1 of 1