ABSOLUTELY.

Misc. Person: Aren't you boys a little young for ...

Phineas: Why, yes. Yes we...

I am not mocking the signature. I am drawing attention to something that most people might...

You are quite welcome.

EDIT: It occurs to me that you might want to substitute "trandate" for GETDATE().

ChrisM@Work (8/22/2014)

---

Brandie Tarvin (8/22/2014)

---

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

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