Viewing 15 posts - 8,836 through 8,850 (of 9,728 total)
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...
May 7, 2008 at 12:38 pm
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...
May 6, 2008 at 9:02 am
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.
May 6, 2008 at 7:49 am
The things we learn, even when we "think" we know it all. @=)
Ditto on the thanks, Paul. You're a good source of info.
April 18, 2008 at 11:51 am
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...
April 18, 2008 at 10:15 am
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...
April 18, 2008 at 8:52 am
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...
April 18, 2008 at 6:00 am
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? ...
April 18, 2008 at 4:46 am
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...
April 18, 2008 at 4:43 am
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...
April 18, 2008 at 4:36 am
guh-ROAN!!!!
@=)
Good one, though. (hee)
April 17, 2008 at 7:35 pm
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.
April 17, 2008 at 9:10 am
You're welcome. Always glad to help.
April 17, 2008 at 9:08 am
Hey, don't Lab Rats get cheese when they thread the maze correctly?
Where's mine??? I want CHEDDAR!!!
@=)
April 17, 2008 at 8:58 am
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...
April 17, 2008 at 8:31 am
Viewing 15 posts - 8,836 through 8,850 (of 9,728 total)