I made use of the built-in datepart functions available in SQL, as many of you also demonstrated. I used a sub-query to obtain the same results. If you want to...

traughberk (5/21/2010)

---

I have a question about LEFT JOIN example near the beginning where he starts talking about EXCEPT where he wrote the following SQL.

SELECT C.CustomerID

...

I agree with WayneS. I have found many occasions where the INTERSECT and EXEPT functions allow for more efficient comparisons between data sets. In the event that I want to...