Move it into the ON clause so it only affects the left join population instead of the result population.

When dealing with outer joins, think of it this way:

Criteria in the...

You're good with what you're using UNION for, but you have to keep in mind that UNION vs. UNION ALL is the equivalent of using a DISTINCT or not on...

Google up Kerberos Double Hop. This is screaming this as the cause, but until you've ran into this headache and a half you're not aware it's hiding out there....

There are things you can change easily in an SSIS package dynamically. The easy way to tell if you can is if they're in the list of properties under...

Ow. Replicating? ...

As mentioned above... no.

However, why would you want to do this? MAXDOP is typically something...

I'm a semi-odd case. I work in SQL Server because it offers me the highest pay of my available skillsets. Rather mercenary but really as long as my...

L' Eomot Inversé (3/4/2013)

---

Oh how things have changed! :w00t:

I remember the days...

Revenant (3/4/2013)

---

I always find it frustrating when someone asks me or someone else to do things for which T-SQL was not meant, in this case parsing multilevel XML with multiple...

Arjun Sivadasan (3/3/2013)

---

Jeff, in this case,...

mickyT (3/3/2013)

---

Hi Craig

I've had a go with your example data using the following and it appears to do what you require ... well the removing of empty tiers

I hope it...

Revenant (3/3/2013)

---

First, IMO BoM is a wrong model for this one: in BoM you can have the same element on several different levels. For example, you may use the 8...

The only thing I've found Connect to be useful as is to be the 'official word of god' from Microsoft regarding bugs in their product. Usually someone with more...

Unlike Jason, I work in a shop where we have a dedicated SSIS box. There are benefits, but they're not readily apparently. However, it's also not a scalable...

I'm forced to agree with the above, this technique is usually best avoided if possible. What problem are you attempting to avoid by staggering your inserts like this? ...