Viewing 15 posts - 8,836 through 8,850 (of 9,720 total)
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
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...
April 17, 2008 at 6:33 am
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...
April 17, 2008 at 6:31 am
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...
April 17, 2008 at 4:51 am
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...
April 15, 2008 at 5:52 am
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...
April 15, 2008 at 4:17 am
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...
April 14, 2008 at 1:10 pm
Michael, thanks for the correction. For some reason I really thought it wouldn't allow FULL OUTER.
Paul, really? Everything I've read said that partial & no caching is much...
April 14, 2008 at 10:56 am
BTW, Pretty sure the issue is the temp table myself since I tried redoing the proc with only the Temp table and not the CTE. Got the same "blank...
April 14, 2008 at 8:19 am
Viewing 15 posts - 8,836 through 8,850 (of 9,720 total)