I'm trying to extract records from table inserted in last seven working days .
I'm unable to exclude Sunday and Saturday from this :
select * from tb_Name where dt >=DateAdd(dd, DateDiff(dd, 0, Getdate()), 0) and
dt<DateAdd(dd, DateDiff(dd, 0, GetDate())-7, 0)
Any pointers would greatly be valued and appreciated .
Thanks .Rajkumar Yelugu
View Complete Post