P Jones (1/26/2011)

---

In my last post every job description was a set format and had as the last item "10 - Any other...

tommyh (1/26/2011)

---

Lynn Pettis (1/25/2011)

---

The sad part about this, "It works on my machine", is that I have seen. I have also the where the code changes work perfectly in...

The article should have emphasized the "small" . When the the data sets get either large or the query is complex you do really need a temp table.

And to agree...

The wording seems clear to me, the output file referred to is one created for success/failure etc and not one created by a previous step.

Agree. Taking code from somewhere else can be a good starting point for a new type of task, but you need to take the time to understand what it does

Developers who forget the magic words "it depends"

Plus of course @k never gets alters (which @j-2 is dependent on)

radu.gheorghiu (2/26/2015)

---

I'm curious as to why in the last example he used a LEFT OUTER JOIN, although in other queries in the article he used LEFT JOIN. From my knowledge,...

Generally a good article, however there is a potential pitfall which should have been mentioned. This is that when using joins you do always have to be aware of...

By definition a toaster cannot be a specific application so

1. Text Editor (notepad++ on windows, gedit on Linux)

2. Spreadsheet for quick data checks/distribution (prefer OO but have learned to deal...