You could always do a LEFT JOIN and just specify a filter based on your @innerjoin parameter

[font="Courier New"]select *

from tableA ta

left join tableB tb on tb.idA=ta.idA

left join tableC tc on...

These types of references are the typical example of why you need deferred updates as they have in Oracle.

In my opinion, 99% these types of "Chicken or Egg" references are...

You could also set one of the records to point to another record or NULL if it is allowed.

Typically, in these circular reference scenarios, one of the records would be...

Check the MDAC version on the older machines, but that seems logical. You probably just have to install a newer version of MDAC on the older workstations.

Your two-instance testing plan is not going to work unless you are able to stop the alternate instance during your tests. The two instances are going to compete for...

You should not use CmdExec - why did you?

What options have you specified?

Are you 100% sure you have used the 64bit DTEXEC?

Your database field is NVARCHAR(MAX) - this is UNICODE.

Your derived column is [DT_TEXT] - this is not UNICODE.

Either make the derived column [DT_NTEXT] or make the database field VARCHAR(MAX).

There must be a more efficient way of doing this, but APPLY would handle it pretty easily.

Jeff may have a way of doing this without hidden RBAR.

[font="Courier New"]DROP TABLE #Sample

GO

CREATE...

Views are just stored queries, so they do not impact performance on their own.

They tend to produce bad queries because they get re-used in the wrong situation. For example,...

MOM is big and complicated. It works very well, but for this it is overkill.

Just go into the "Alerts" section in your SQL Server Agent node in Management Studio...

If you must use word, you would need to write some VBA code in the word document to react to the save event of the document. Assuming your users...

Make sure you look closely at the support offered for VMWare and SQL Server. It is only partially supported and with particulare versions of VMWare.

I have had good and...

I don't see a question.

Use option #2.

I would recommend using logging if possible.

Barring that, one option is to use multiple execute SQL tasks and put them at whatever point in your package you want to insert...

Sorry, I didn't want to code inserts with all of the additional columns.

The important parts are where I put comments - order the insert by the original identity column and...