It would be along the lines of

1/3/05 12:00:00AM - 4 open records

1/3/05 1:00:00AM...

One of these days I'll actually recognize for myself when to use a tally table 😀 I have one built but didn't think to use it. ...

Sorry about not including the details to start with. I've been lurking around here long enough to know better. Tables and sample data are below with code...

Always, always, always be completely up front both on your resume and during an interview about what you do and don't know. Any job I've ever taken,...

In the beginning, the universe was created. This has made a lot of people very angry, and is generally considered to have been a bad move.

---

"You'd better be prepared for...

chris.compton (2/12/2008)

---

Oh, that makes sense. I've heard the term "candidate field" (with the meaning being "one of the fields in the table which we could use as a key")...

Well said Mike.

I'm going to assume you include data integrity as part of a well performing application 😀

SteveRowland (2/11/2008)

---

Without an SID, how would you store multiple addresses for a person, and be able to modify a single address, without using every field in the address? Would you...

Matt Miller (2/11/2008)

---

That's an interesting thought, but there are times when you might get the same data (say - you're tracking outcomes of consecutive coin tosses). There really might...

Many of the responses I'm seeing here just confirm for me why I'm very skeptical of people who just use some kind of artificial key across the board. ...

george sibbald (2/1/2008)

---

Judging by previous replies I will be controversial and say NO to SQL 2000 SP5. I think it is widely accepted that 8.00.2187 is the roll up to...

Not everyone is on...

Thanks Joe. Looks like exactly what I'm looking for.

Thanks Vivien, there is a lot of good information there that I will be able to use. However it doesn't really address any of my questions regarding the...