Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag DISTINCT Rss

Search for any content tagged distinct

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 2 of 2   
 

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 2 of 2