Another option not depending on the CONCAT_NULL_YIELDS_NULL setting would be using (col1 IS NULL OR col2 IS NULL) instead of (col1 +col2) IS NULL...

I'm sorry!! I missed the second part of the requirement...

Here's the expanded constraint:

ALTER TABLE #temp

ADD CONSTRAINT chkCol1Col2 CHECK ( (ISNULL(col1,col2) IS NOT NULL) AND (col1 + col2 IS NULL));

It...

I don't really understand what your table actually looks like.

Would you please post the table def, some sample data, your expected result and what you've tried so far? For details...

So, I guess sp_help_jobhistory together with ROW_NUMBER() will help here. Please...

Please have a look at BOL (BooksOnLine, the SQL Server gelp system usually installed together with SQL Server, accessible via F1 from Management Studio). Search for the "CREATE XML SCHEMA...

Would a CHECK constraint help?

ALTER TABLE YourTable

ADD CONSTRAINT chkCol1Col2 CHECK ( ISNULL(col1,col2) IS NOT NULL );

This constraint would allow you to insert a NULL value either for Col1 or Col2...

What exactly do...

Richard M. (5/17/2010)

---

... you can't "inject" an error to another SPID....

As far...

Not sure what you're trying to do but maybe RAISERROR will help (see BOL for details).

Another strong hint: you might want to remove your email address. If people feel the need to provide you with a sample they can drop you a PM...

The requirement is not clear. Do you want to list only jobs where the last run and the one before failed, job that have failed twice (as per available log...

duplicate post.

Already answered here

neelsmail (5/16/2010)

---

> You still haven't explained what you're trying to do 10,000 times a second...

I thought I did.. but perhaps I didn't understand your question.

I am trying to call the...

So, what does that sproc do that takes 3min?

Nope, it's the other way around: you SEND a message to the Service Broker queue and within the...