Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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 | 868 reads
   Items 1 to 1 of 1