OUTER APPLY is very different from OUTER JOIN which is where you would expect to see "the condition to join the tables".

From http://msdn.microsoft.com/en-us/library/ms175156.aspx

The APPLY operator allows you to invoke a...

I thought that's what I said 😀 Glad you found it!

sp_helprotect is deprecated but in my opinion is easier to use than its recommended replacements sys.database_permissions and fn_builtin_permissions. This page is for sp_helprotect, note the "Important" message at the top...

Re-read the error message.

Who owns sqluser_schema?

Awesome thread all 🙂

Craig Farrell (4/26/2011)

I didn't go through everything, but that's not a triangular join. This...

That's fantastic! I am happy you figured it out...and yes, I hope someone else finds this thread in a time of need. It's great to see that IMEX works with...

AFAIK the CommandTimeout property of the DataReader Source is what you want to change. It's on the "Component Properties" tab. Is that...

Not that no one in here will be able to answer but you may have better luck finding Oracle help in one of the "Working with Oracle" forums:

SQL 2005: http://www.sqlservercentral.com/Forums/Forum1042-1.aspx

SQL...

Lamprey13, thanks for your take. Your solution took quite a bit longer than Jeff's solution on my machine so I timed it to get an idea of the differences...with IO...

Thanks for posting back. Still using Jet huh 🙂 I was hoping you were using ACE.

I am looking to move everything to the ACE 12.0 under the new 2010 Office...

I don't know what you mean by "hitting a web site" to get the data, and/or if it's related to the OpenAccess DataDirect driver you're using, but I have created...

Keep at it...personally I never use bcp from a stored proc because it means I have to enable xp_CmdShell which is a security risk and so I choose not to...

You can use a CTE in combination with a MERGE statement. Something along these lines should work for you:

WITH cte

...

Please post the DDL for your tables, some DML to create sample data and the desired resultset.

if you have questions as to what I mean please read this article:

http://www.sqlservercentral.com/articles/Best+Practices/61537/%5B/url%5D