MERGE has the same problem after a UNION ALL. It doesn't think the sources are sorted. And the idea behind using a MERGE JOIN was to compare records...

Thanks for the ideas, guys. I appreciate the input.

Now I just have to test it.

[edit] BTW, where exactly is the UNION component that is not a UNION ALL? ...

Paul,

Thank you so much for the link. It is greatly informative. And BOL wasn't the only place I saw the stuff on Full Caching. There are a...

Michael,

Thanks for the redone CTE thing. I'm still learning a lot about these.. But are you able to do a double CTE and still get the fields? Because...

guh-ROAN!!!!

@=)

Good one, though. (hee)

Grrr. That's annoying.

Do you know of anyway to sort the output of a UNION ALL? I can't find one, but that doesn't necessarily mean anything.

You're welcome. Always glad to help.

Hey, don't Lab Rats get cheese when they thread the maze correctly?

Where's mine??? I want CHEDDAR!!!

@=)

Mark,

What we were willing to do was to tell you not to lie and how to improve your skills so you wouldn't have to lie. Yet you seemed to...

Lynn,

Good catch!

I know my manager has been known to Google prospects before doing the phone interview. In fact, he did it just a few weeks ago on the last...

It definitely makes me wonder about the "manager is a Nazi" comment if he lies to get into the job, then admits his first week he was hanging out and...

Whenever I see that problem, it's because people are trying to use SSIS to pull data into a 2000 destination from a 2005 source. Unfortunately, SQL 2000 doesn't recognize...

So far the only resolution I have found is to stick an Execute SQL Task right before my Data Flow, modify the Proc to stick the data in a real...

That's pretty much what I did the first time. Did it again and got the same error message. I'm wondering if it's a combination of the CTEs and...

I tried following your suggestion and got an immediate failure.

Error message is: Column "MyColumn" cannot be found at the datasource.

The OLE DB Source has ValidateExternalMetaData set to false. It...