Here is a case that would be better not using Merge. I would just have two separate statements, one the updates rows and one that inserts based on the join....

You should try to figure this out for yourself. If we do your homework for you you will not learn anything, and subsequently you will never be in competition for...

In essence, what you want is for the C# application (or thread) to be waiting (sleeping) for an event that comes in the form of a message sent from SQL...

I wish all of my fellow compatriots here on SSC much success and happiness in the coming new year.

I have been wanting a nice notebook/laptop computer to replace my old clunker Windows XP machine. It would be wonderful to get it as a gift but that won't...

Welcome. And Merry Christmas to you.

you should create your import table with the correct data type for each column.

As an alternative, you can insert the data from your stage (import) table into a second table...

SQLChar is unicode character. CLR String is unicode, but the file you create probably isn't unicode.

Sounds like the problem is not being aware of what is unicode...

try it this way:

Select top 1 @AppUser = UpdatedBy FROM '+ @TableName + ''

Actually have not needed to do any specific masking operations on the IP addresses as we are looking up the region (city state, country) and organization for fraud detection purposes....

For some tables I store it as a bigint (convert to bigint via CLR function in insert). Very efficient and works well for huge tables or ones that might...

I would use two folders, one for the current days worth, another archive folder for the two older days. Run a local job to move the previous days files over...

I would use robocopy to mirror the two folders. It will delete files at the destination as they are delete at the source.

Glad you got it working! Ho Ho Ho

try something like this:

select SOID, DetailID, O.ItemID, ItemType, isnull(R.ItemID,O.ItemID) as equipGroup

from Orders O

LEFT JOIN RelatedItems R on O.ItemID = R.RelatedItem