Posted by Techhead on 02/08/07 19:15

On Feb 8, 12:57 pm, "Techhead" <jorgenso...@gmail.com> wrote:
> On Feb 8, 12:41 pm, "Plamen Ratchev" <Pla...@SQLStudio.com> wrote:
>
> > You can return all records with today's date using a WHERE condition like
> > this:
>
> > WHERE mydate >= DATEDIFF(day, 0, getdate())
> > AND mydate < DATEDIFF(day, 0, getdate() + 1)
>
> > HTH,
>
> > Plamen Ratchevhttp://www.SQLStudio.com
>
> Awesome! Worked perfect!

Now how can I get a SUM of all records returned by this query. I know
SELECT SUM(*) AS TOTAL FROM does not work. What else can I try?

[Back to original message]