Gary Varga (12/18/2015)

---

Yes.

So are many employers.

Ideally the worst employers get the worst employees and vice-verse. Strangely enough this is what I have tended to see. The worst employers lose all...

Thanks for the script.

Can't wait to move up to 2012 and take advantage of the LEAD and LAG.

I am assuming that if you don't specify a value to be used in case there is no next year, that it returns zero as the default.

I noticed the data type missing too.

I always use explicit words for my joins.

Thanks, have used this a time or two.

Thanks for the question.

kmpa (12/17/2015)

---

I'm not so sure about the article's assertion that the credit card companies are suffering losses. In my experience, it is the business that accepted the fraudulent card...

Thanks for the script.

Thanks for these.

What some of the others are missing is that you are hunting for the one that will return the record containing the text 5%, not any record with a 5....

Clearly left off the group by

We must be political correct.

I'm not familiar with what this is but the script looks like an interesting exercise to go through.