Web Listing 1: Sample Query with Set Operation
USE Northwind;
GO

SELECT CustomerID, EmployeeID
FROM dbo.Orders
WHERE OrderDate >= '19960101' AND OrderDate < '19970101'

INTERSECT

SELECT CustomerID, EmployeeID
FROM dbo.Orders
WHERE OrderDate >= '19970101' AND OrderDate < '19980101';