rbarryyoung (11/30/2008)

---

Heh. You know the first time I read this I thought that you said "Partitioned Table". I didn't realize until...

I know Steve will step in on very rare occasions, but, for the most part, nothing get's moderated out of the forums on SQLServerCentral.com. What you see, is what...

Jonathan Kehayias (11/30/2008)

---

Most of it is misplaced, but there are some areas that it actually makes sense to put code in CLR, they just don't generally fit in most common...

... and I was talking a bit more genericly...

GilaMonster (11/30/2008)

---

Jeff Moden (11/30/2008)

---

I still want to know what the CLR(s) the op wants to write do. We all know that too many people give up on T-SQL...

Just in case you already read the above, I had forgotten the "END" for each CASE in the code. I've corrected the code.

Not sure why they're exactly doubled because you've created an "accidental cross-join" and they should be a lot more than just doubled. Moot point, though. Let's fix...

Yes... all joins basically fall into 3 categories behind the scenes... Hash, Merge, or Looping. A 10,000 foot overview for each is availbable in Books Online (BOL) and the...

I agree with Gail... those are about the only things I use triggers for. That includes the ability to keep people from changing DateCreated/Modified or CreatedBy/ModifiedBy columns. Other...

The cool part about your solution, Chris, is...

... it's not dynamic SQL... just good, clean, hard-coded concatenation.

GilaMonster (11/30/2008)

---

No prob. I was just worried that...

Great information, one and all... but I still want to know what the CLR(s) the op wants to write do. We all know that too many people give up...

Chris Morris (11/30/2008)

---

Jeff Moden (11/29/2008)

---

Heh... not to worry... it's not as bad as that dummy that thought the sum of the differences between two points could be used to determine...

Wow... last guy I heard of that happening to had to have major reconstructive surgery... you're a lucky...

Jonathan Kehayias (11/29/2008)

---

Jeff Moden (11/29/2008)

---

Jonathan Kehayias (11/29/2008)

---

I'll never understand the attitude that I see people take, when the post a simple question and someone posts a BOL reference instead of...