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 . ....

Well, how do we go from here:

I made some applications in...

Jeff Moden (2/14/2009)

---

Lynn Pettis (2/13/2009)

---

Jeff, I'm not sure if you are right or wrong still. I ran the following and everything ran fine. Can you suggest any other...

Jeff, I'm not sure if you are right or wrong still. I ran the following and everything ran fine. Can you suggest any other tests I may want...

Jeff Moden (2/13/2009)

---

Absolutely. And, since you can't use an index by name...

Lowell (2/13/2009)

---

dunno why i keep looking at this...

you can add a trigger on the VIEW to handle the status column....

rename the original table.

--add a view that has the old table...