Roy Ernest (9/4/2014)

---

Thx guys..

There was not SQL Saturday this year. We will have one during memorial day weekend next year.

Jack, hopefully we can meet each other this time...

Grant Fritchey (9/4/2014)

---

In answer to your second question... It depends. Let's say we're talking about a marginally complex query with no underlying issues. Yes. But, let's say we're talking about...

nishav2 (9/4/2014)

---

Hi,

In C: drive i have many folders .

For example folders named like ABC,ARD,AVB,BGT,BHT etc...And these folders has many subfolders and files in it.

My Task is to search for a...

jcrawf02 (9/4/2014)

---

You mean the show about the conceited narcissistic prick who is unable to properly interact with other humans because he's convinced of his superiority, and constantly causes pain and...

Why? So you could cheat on the question?

Nah, Chris Date would...

brett.y (9/4/2014)

---

Thanks for the help!

It is true (of course) that the WHERE clause sorts out the LEFT OUTER JOIN (thanks). The only niggle is I remember moving the a.batch...

With a LEFT JOIN, you take all the rows from the left table.

If AP4_packing_leg1_HSM_status has 7 rows, you will get 7 rows.

Putting a.batch = 105 in the ON clause doesn't...

Knut Boehnert (9/4/2014)

---

Interesting teaser post. I am working on a similar project currently to rewrite our Data Warehouse and Benjamin made a good point to show that DV is not...

smart_analyst (9/3/2014)

---

I tried again with new project and new package. All 4 Execute SQL package works outside Sequence container but, inside the 1st Exec SQL package fails.....

Does anyone else...

Nice one, thanks.

Nice question, thanks.

This is a blog post, not a technical article.

Nice story, but I expected at least some scripts...

I hope this is an introduction to a great series about the combination of...

Bah. I couldn't resist it.

Well, at least his English wasn't that bad 😉

And he didn't use ISNULL, seeing you have quite the aversion for T-SQL.

CELKO (9/3/2014)

---

You do not know that...