Since you already know the basics of SQL, you can read this TSQL book by Itzik Ben-Gang (it's not that easy, but you'll learn a lot from it):

Microsoft® SQL Server®...

Read the question. Read it again. Read it again and now pay special...

Thanks, great question.

I first thought: "statement 1 doesn't return a row at all!" Then I read the question a little better 😀

As I said before, SQL Agent will ask you for...

GSquared (8/1/2012)

---

Koen Verbeeck (7/30/2012)

---

GSquared (7/26/2012)

---

You can't cluster SSIS, but you can have it running separately on each node, which accomplishes much the same thing. All it really means is...

L' Eomot Inversé (8/1/2012)

---

ChrisM@Work (8/1/2012)

---

dwain.c (7/31/2012)

---

SQLRNNR (7/27/2012)

---

Really unfortunate - I would love...

ChrisM@Work (8/1/2012)

---

The WHERE clause doesn't generate an output column. Ever.

There are four well-known ways to calculate running...

Well, the code is meant to replace UNION, so that's possible 😀

Cadavre (8/1/2012)

---

Also looks like your extra left join may...

Allright, I managed to rewrite the query without using UNION or UNION ALL:

SELECT COALESCE(A.ID,B2.ID), COALESCE(A.Value, B2.Value)

FROM

A

LEFT OUTER JOIN

B B1

ON A.ID = B1.ID

FULL OUTER JOIN

B B2

ON B2.ID = B1.ID

WHERE B1.ID IS...

If you use UNION ALL the Distinct Sort operator will be removed from the query plan and performance won't be that bad. Are the two SELECT queries just simple selects...

The issue is with the /connection property, not with /decrypt. Normally, the package will be decrypted by your user key (as the protection level suggests) so you wouldn't need to...

You can't add an alias in a WHERE clause, so it's probably a mistake in the article. It probably needs to be appended after SUM(b.Sales), not after the WHERE clause.

The...

What's wrong with union?

Since TSQL offers only union, intersect and except, any solution that I can think of right now involves union.

Can you edit properties of the report? Maybe try a redeploy from Visual Studio.

This question could have been so much more than just a simple trick question. Instead of focusing on attribute or element centric mapping (which you did a bit with the...