The where clause is filtering out some row that has a value that throws that error. With the where clause, the row is not in the resultset and the conversion...

No.

Main problem is that it's pretty unlikely for the last select to be the one that throws an error, so the error handling (which is pre-SQL 2005 style) is mostly...

What is this supposed to be doing?

You want this changing to an in-line table-valued function?

Brandie Tarvin (3/10/2015)

---

SQLRNNR (3/10/2015)

---

Jack Corbett (3/10/2015)

---

SQLRNNR (3/9/2015)

---

Jack Corbett (3/9/2015)

---

So this means if and when I meet Gianluca he'll...

There are definitely times when shrinking is fine. I actually have a scheduled weekly shrink job on my dev server. That said, if you're so space-constrained that you're repeatedly shrinking...

There is nothing at all in your code which ensures that multiple people won't get the same department number. Yes, you have an updlock, but since there's no transaction, it's...

Could you post a few more rows of sample data please?

The Standard Edition I could live with (if it was...

Where to start....

Well, firstly, that trigger won't even create, so it's going to be pretty hard to tell you what's wrong with the trigger that you're running, as it's clearly...

JarJar (3/10/2015)

---

"separation of databases which don't play nice together" is my answer. sharepoint must be on its own instance, bi on it's own instance, application databases on their own, infrastructure...

Partitioning is not done for performance reasons. It's for data management, fast loads and fast deletes. It won't necessarily improve performance, it may, in fact, reduce performance.

If you're looking for...

Well you can start by removing the nolock hints, since they allow SQL to return incorrect results.

XactAbort removes the need to try/catch, but if you want multiple statements to be atomic (all succeed or all fail), you need an explicit transaction.

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

The SQL parser does not and can not execute code. It's a parser. It encounters the same temp table being created twice, hence throws an error.

Solution: Create the temp table...