Great question, thanks.

Nice article.

Does the email have some formatting? Does in include a signature from the Community Health Network for example?

(I noticed you have a column indicating HTML formatting)

Yes, but that's only because most of the regular...

There is some data displayed, in the bottom left...

Eugene Elutin (10/8/2014)

---

Cool links, thank you!

Guys, you will...

Sean Lange (10/8/2014)

---

Ed Wagner (10/8/2014)

---

GilaMonster (10/8/2014)

---

Sean Lange (10/7/2014)

---

Oh no. I assumed...

Thanks 😀

My frustration levels were reached when...

Which point? The two CTEs to one, or the terminator?

Ugh. Can't we block that guy?

Put the data flow loading the flat file inside a for each loop.

Configure the for each loop to look only for the filename of that flat file. If it isn't...

This must be the most retarded comment in the entire history of SSC.

Who cares what the amount of comments was on a question...

SkyBox (10/8/2014)

---

I'm not looking to view passwords, but instead query for passwords that don't meet the requirements so that I can get them corrected. I'm working with thousands of...

Ed Wagner (10/8/2014)

---

Greg Edwards-268690 (10/8/2014)

---

Ed Wagner (10/7/2014)

---

Evil Kraig F (10/7/2014)

---

I'm Crazy!

I am NOT!

Yes, I AM!

Dammit, you two, shut up! This isn't getting the four of...

DBA From The Cold (10/8/2014)

---

I'm not sure that you will be able to script this out (as you cannot see what users' passwords are).

I would ensure that users are specifying...

Sure, you can use the first CTE as a subquery in the second CTE, resulting in only one CTE.

But semantically nothing has changed, since CTEs are subqueries anyway. The execution...