DaveDB (1/14/2014)
Simple enough Phil.... And I didn't need a unicycle 🙂Please refrain from patronizing people. Not everyone is an expert and we are all trying to learn at our own pace. I find your comment very insulting. It's very disturbing when the first thing you see in the morning is some egotistical guru throwing insults around because he has nothing better to do with his time. This forum was designed to help people out, not point out shortcomings.
BTW: Here is the answer. As basic as the question may have been. You see... This is called "learning".
DATEPART(dw,Datestamp) IN (1,7)))
Don't feel insulted, it's only a SQL Server forum. Not only that, but I reread my post and there was no insult.
But there was a message:
Had you provided executable code when you asked the question, along with actual and expected outcomes, it would have been answered sooner and with less fuss.
I was hoping that you would take that on board for any future posts.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.