Jeff Moden (7/16/2010)

---

...using IDENTITY in combination with some table and index hints, have been able to resolve the ones I haven't be able to avoid (guaranteed multi-row inserts over a...

Steve Jones - Editor (7/16/2010)

---

I think his initial argument seemed to be that the way he was upgrading his code (lower stack stored procedures) to the new error handling resulted...

bteraberry (7/16/2010)

---

I guess it depends on what you mean by being a mess. I find the error handling in T-SQL very underwhelming, but every single example I've seen results...

Sort of, but not really. You're very limited in...

Lynn Pettis (7/16/2010)

---

You were wrong to call him stupid. It was unprofessional and uncalled for in this forum. You insulted, not only him, but all of us on...

I agree. If I were Steve, I'd be having a quiet word right about now.

Not that Steve needs...

Ah! Still, your English is excellent, especially considering it's not your first language.

BTW, the Scottish half doesn't feel comfortable with...

No, you need to upgrade to SP3, then again to Cumulative Update...

Top marks for persistence, but the answer is a polite, but very firm, no.

Try starting your own thread for your problem, others may be willing to help.

Hey Tom,

You know Gianluca's Italian, right? 😛

Paul

It's precisely because hierarchyid is available in 2008 that I wrote it.

There is no easy equivalent in 2005.

Sorry about that.

Well.

There's nothing wrong with finding T-SQL error handling a bit odd. Some errors terminate the active statement but continue processing the batch, some abort the scope, some abort the...

Which script?

P.S. I never respond to unsolicited emails

Grant Fritchey (7/16/2010)

---

I'm just impressed in the absolute certitude in the face of apparently overwhelming negation. I'm right the universe is wrong. They laughed at me at the academy. It's...

I hope it's not too late to chip in some extra thoughts on this.

What you are doing is known as a local partitioned view. It uses the same idea...