Then instead of

WHERE DATEDIFF(MONTH,a.trans_date,a.due_date) >= 2

Try

WHERE a.due_date >= DATEADD(m,-2,CONVERT(DATE,GETDATE(),101))

This gives you every date...

ChrisM@Work (8/22/2014)

---

It's concatenation of values from different rows of the same column, Brandie.

Split up the email addresses onto different rows, eliminate any...

Chris,

Why the STUFF() and the XML?

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...