Phil Parkin (1/13/2014)
You've been a member of this forum long enough to know that you need to provide DDL, sample data and desired results in a consumable format in order to get a working answer.Please follow the link in my signature if you need a reminder of how to do this.
For English installations...
OR DATENAME(dw,Date) IN ('Saturday','Sunday')
--Jeff Moden
Change is inevitable... Change for the better is not.