Steve,

Look at Chris's code carefully, because he makes a point I think you missed. OUTER JOINs don't work as OUTER JOINs when you explicity reference the columns in the WHERE...

djj (8/22/2014)

---

Brandie Tarvin (8/22/2014)

---

lpablo (8/22/2014)

---

DECLARE @Email VARCHAR(100)

DECLARE @Email2 VARCHAR(100)

Set @email= 'helper@sql-server-helper.com'

set @email2='fff@dd.com, helper@sql-server-helper.com,vc@.com'

SELECT case when @email2 like '%'...

Important questions. What data type is DueDate? DATE or DATETIME / SMALLDATETIME?

If a DATETIME variety, do you need everything from midnight on or are you looking for literally 2...

Aaaannnnnddddd... From the theatre of the absurd, I couldn't get PATINDEX() to work, but I did get CHARINDEX() and REPLACE() to work. I don't know why anyone would want to...

Myke85 (8/21/2014)

---

How I can get 'good'?

DECLARE @Email VARCHAR(100)

DECLARE @Email2 VARCHAR(100)

Set @email= 'helper@sql-server-helper.com'

set @email2='fff@dd.com, helper@sql-server-helper.com,vc@.com'

SELECT case when @email like...

lpablo (8/22/2014)

---

DECLARE @Email VARCHAR(100)

DECLARE @Email2 VARCHAR(100)

Set @email= 'helper@sql-server-helper.com'

set @email2='fff@dd.com, helper@sql-server-helper.com,vc@.com'

SELECT case when @email2 like '%' + @email1 +...

Bah... Crosstabs...

Why, yes. Yes I am.

Luis Cazares (8/21/2014)

---

Do you at least understand...

Perry Whittle (8/21/2014)

---

Curious, how...

happycat59 (8/21/2014)

---

As db_owner, you...

Myke85 (8/21/2014)

---

How I can get 'good'?

DECLARE @Email VARCHAR(100)

DECLARE @Email2 VARCHAR(100)

Set @email= 'helper@sql-server-helper.com'

set @email2='fff@dd.com, helper@sql-server-helper.com,vc@.com'

SELECT case when @email like...

And that's what happens when I forget how to read a post all the way through. @=)

On another note, I recently found that I can also just break the mirror from either the primary or the secondary as per this BOL note. So it all depends...

Bean

Except when buying a car, I have no intention of offering the highest possible price first. @=)

Snafu