Web Listing 4: Query Implementing INTERSECT ALL
WITH INTERSECT_ALL AS
(
  SELECT Country, Region, City,
    ROW_NUMBER() OVER(PARTITION BY Country, Region, City
                      ORDER BY (SELECT 0)) AS RowNum
  FROM dbo.Customers

  INTERSECT

  SELECT Country, Region, City,
    ROW_NUMBER() OVER(PARTITION BY Country, Region, City
                      ORDER BY (SELECT 0)) AS RowNum
  FROM dbo.Employees
)
SELECT Country, Region, City
FROM INTERSECT_ALL;