Sorry to break the rules but..

I've possibly discovered a bug that corrupts your db when doing a deployment script. I've tested on 2K5 sp3 and 2K8 R2 RTM, I...

Hey guys, finally got around to building a demo db that still fails the exact same way my "prod" db was failing.

This data is 100% obfuscated and only a 3...

koustav_1982 (8/16/2011)

---

HI All

The question is what happens to the statistics information , when a database is restored from an environment to the other without the stats related configuration in...

Medhatithi Guha (8/15/2011)

---

Is this sql server 2005? Then run a profiler and capture the deadlock graph. Deadlock can occur because of a lot of reasons and the deadlock graph will...

Steve Jones - SSC Editor (8/15/2011)

---

JamesMorrison (8/15/2011)

---

Steve Jones - SSC Editor (8/15/2011)Certifications can help there, especially as some HR departments use them as a filter. When you get 100 resumes...

@chris-2, please read the whole article I posted. All your questions will be answered there.

Glad...

GilaMonster (8/15/2011)

---

Ninja's_RGR'us (8/15/2011)

---

GilaMonster (8/15/2011)

---

Kiara (8/15/2011)

---

No matter what career field you want to move into, you might want to rethink the way you both think about women and talk about...

GilaMonster (8/15/2011)

---

Kiara (8/15/2011)

---

No matter what career field you want to move into, you might want to rethink the way you both think about women and talk about them -...

SQL Kidd (8/14/2011)

---

I'm being very sincere when I post the following comments, would not having a certification and being a young black male add as a counterproductive force for...

If that means anything... I've been working in IT for 8 years, never got certified and never was a issue to not get the job.

The only times I got refused...

Been there... google is awesome ONCE you know what you're looking for 😉

HTH.

You can use the output clause in merge. BOL has good exemples.

My first instinct is to use left join here but I'm not sure I understand what you need.

So all in all your query works fine but you want it to...

If that's the only change you've made to the package and that's when the error occured then yes it's a very good bet that you have dates outside the smalldatetime...