You can find a few more of these types of date calculations here: Some Common Date Routines.

shifty-922587 (1/21/2010)

---

I was actually trying to pull in the date (emp.hiredt), and calculate the next month first date.

I would like to know if I was told correctly about...

Again, NOPE. Luck implies a...

shifty-922587 (1/21/2010)

---

I was playing around with some code for showing the date and added the value -10 to this query:

DATEADD(mm, DATEDIFF(mm,-10,emp.hiredt), 0)

end) as eligdt

I was told that this slot...

Nope.

david.wright-948385 (1/21/2010)

---

How'd you do that without knowing which version of SQL Server it was asking about, or whether the model database had...

mtassin (1/21/2010)

---

Lynn Pettis (1/21/2010)

---

Have you checked model to see if that is how it is configured on each of the systems? You may not have fiddled with model, but...

Duplicate post, please post any responses here.

mtassin (1/21/2010)

---

2 MB mdf, 3 MB ldf here, and I know I haven't fiddled...

He was questioning the spelling of mesmerizing.

Some stress is good, some stress is bad. I have found, personally, that there needs to be some level of stress in the environment in order to get things...

Wish I could, unfortunately when people purchase 3rd...

I have to agree, experience is more important. I have been working with SQL Server for over 12 years, no certs. I'll also agree that you have to...

Yea, can see it now:

Assisted SQL...

Hard to say, but this error, Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.), could be the result of...