David,

When you say you can't create it, what problems are you having?

AHHA! I knew I had to be missing something.

Thanks, Guys. That clears things up. @=)

BTW, thanks to all who replied to this thread. Your help has been greatly appreciated.

I don't want to put the entire SQL in my source because of SDLC issues. Every time I have to edit an SSIS package, I have to do all...

It might be. I have to test it.

Interestingly enough, when setting up Linked SQL Servers in the 2005 GUI, it doesn't allow you to assign a different name than...

This is odd. I could swear I've heard people talk about creating synonyms for their Linked Servers....

I guess I have more research to do.

The things we learn, even when we "think" we know it all. @=)

Ditto on the thanks, Paul. You're a good source of info.

Bill,

Have you tried the other possible resolutions on this thread already?

If so, search TechNet (Microsoft's web site). If the ticket was called in and resolved, there might be a...

Wow. I start my best topics when I'm tired. @=) This is such a fun one!

Beer with me. I Brin trying to remember All-gauer Emmentaler the cheese...

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.