Not saying that at all. I'm focusing on what everyone else is focusing on, which is not about the wording of the question.

Do you have a backup of the database prior to when the data was deleted?

Did this error just start happening or have you been getting a while? When it started had there been ANY changes in the database, app, OS, network, etc? ...

Is the data restricted to a 12 month period or is there more than one year?

Also, referdate would go in place of getdate().

Bru Medishetty (11/19/2009)

---

Bru Medishetty (11/18/2009)

---

forumdog (11/18/2009)

---

Alot of very rude and what appears to be blatant disrespect and rudeness so far. Okay you arrogant and unhelpful people. May life and God...

Forget the question for a bit. ...

Not only that, even when the next best thing since sliced bread does arrive, SQL isn't going to go away over night. Want proof, look at COBOL. I...

Mayhem? I didn't see any mayhem. Lots of disgruntled posts, yes. I learned quite a bit from the discussion that ensued, some of it not directly related...

Start with, I must, it depends.

I guess it would help if you provided us with an example. If it would mean writing a multi-statement TVF, unless you could guaranttee...

rparakalla (11/18/2009)

---

Lynn Pettis (11/18/2009)

---

rparakalla (11/18/2009)

---

Yes I would also agree. The names may be different but refer to the same person. So they are equivalent. But the output of getdate() and...

rparakalla (11/18/2009)

---

Yes I would also agree. The names may be different but refer to the same person. So they are equivalent. But the output of getdate() and getutcdate() is different....

Just found out something about forumdog, he isn't even a lurker. Joined today and copt such a 'tude on his first post. 😛

Know what, I wouldn't be surprised if...

dstemate (11/18/2009)

---

the correct answer is False.

Even though the local an UTC represent the same time, when you compare them just as datetime with no referece (local or UTC) they are...

archie flockhart (11/18/2009)

---

Lynn Pettis (11/17/2009)

---

So, you are saying that if I run the following code:

select getdate(), getutcdate()

that the values are not equivalent? Why? They both represent the same...

Pork Chops? No, those are Cardinal Moden's specialty! 😉