Have you tried it without the conditional for just the first column so see if the conditional is causing the problem?

RAISERROR does not abort the batch. The process will continue after a RAISERROR unless the RAISERROR is withing a TRY...CATCH block. In a TRY...CATCH block RAISERROR sends it...

I think you want sys.server_triggers

If you are using either Michelle Ufford's or Ola Hallengren's index maintenance script which checks index stats so that maintenance is done only on indexes that need it, then you...

You can't reference table3 because it isn't in the query. Shouldn't it be table1.k1 = T2.k1

He will as long as there aren't any almonds. 😛

Jim Murphy (11/22/2011)

---

The other organizer of our SQLSaturday in Austin (#97) just compiled the speaker feedback evals. I came in 3rd overall! I'm pretty pleased since it was...

Check out the last 2 articles linked in my signature.

Rob-350472 (11/23/2011)

---

I'm trying to colour a range of values with the following approximate categories:

= 0.00

+/- 0.01-0.03

+/- 0.04-0.20

+/- 0.21-0.99

+/- 1.00+

As you can see basically distance from zero, zero should be white,...

Here's an article[/url] that talks about how to do it. Be sure to look in the discussion as well because there is a link to a custom component I...

Andeavour (11/23/2011)

---

Sounds like the package is using your authentication when you're logged in to Management Studio, and presumably the Agent account authentication when your not, and I would guess the...

What is the error message?

Usually you specify the name when you attach a database to a new server. What did it get named?

I believe you could develop the reports in 2008 and deploy to R2 but when deployed they might get upgraded to the new format and not be able to be...

I haven't played with 2012 yet, but do the tabs float like in VS 2010 so you can have each tab on a separate monitor? That might be reason...