I'd like to hear Hugo's answer to your question, but IMHO not much really changes in SQL Server 2008 with regard to the DATE and TIME data types. When...

Jeff Moden (2/17/2009)

---

Lynn's suggested changes are a great way to start. What he failed to mention is... why. Even if you added a pot wad of indexes to...

arun.sas,

Is everything working okay?

And this is my code changes using left outer joins. Of course, with no tables and sample data, I can't test it:

DECLARE @CurrDate AS datetime

SELECT @CurrDate = '2009-02-02'

DECLARE...

Here is my first shot with minor changes. I would also look at moving some of the subqueries into left joins in the FROM clause, but I'll wait a...

What is the data type for this column: AttendanceDateTime.

Double posted, please use this thread.

Many years ago as a young airman stationed in England, my first supervisor did something I don't see many others doing. He taught me to read the technical manuals....

jduncan (2/17/2009)

---

Ok, new to SQL Server so bear with me..

...

Coming from my MSAccess roots this seemed pretty simple, but has cost me a good day of hair pulling.

Not...

Back to the topic at hand (at least for the moment). Both products have their place or else they both would not exist. Where I may only be...

And yet,...

SELECT

* -- really should specify the columns you need, even if it is all of them, if not a covering index may be of benefit

FROM

...

Thinking and Reading that would mean. On silver plater answer should be.

skjoldtc (2/17/2009)

---

Points schmointz... who cares?

The takeaway is that SQL Server rounds time and don't use BETWEEN with a date range. But, this seems such a strange way to do this....

Derek Dongray (2/16/2009)

---

This isn't actually a bad question, but my thought when I read

louisevb (2/16/2009)

---

I have decided to change my career from accounting to Database Developer (BIG change . ....