Find Weekend Days In A Date Range

[Scooby62]

Does anyone know how to find weekend days in a date range. These would be Saturdays and Sundays.

I have a date range of July 29/04 to July 29/05 in which I want to deleted data entry for any Saturday or Sunday.

If anyone can help I would be ver greatful.

Thanks so much.

 

[dbomrrsm]

SET DATEFIRST 1 -- sets first day of week to be monday
DELETE from mytable
WHERE DATEPART(dw,mydatefield ) IN (6,7)

test this as a select first to make sure !!!

DBomrrsm