Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts by Clyde Merrell 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: | Category: union
Rating: |  Discuss |   Briefcase | 896 reads
   Items 1 to 1 of 1