In SQL Server UTF-8 collation is only available with SQL2019.

With SQL2016,  you might be able to get away with importing into a varchar with a French collation. (eg French_100_CI_AI)...

You will get a quicker reply if you post consumable test data:

CREATE TABLE #t
(
   emp_id int NOT NULL
   ,check_in datetime NOT NULL
 ...

• This reply was modified 2 years, 9 months ago by Ken McKelvey.
• This reply was modified 2 years, 9 months ago by Ken McKelvey.

It is difficult to tell exactly what you are doing but a trigger on a log table sounds a bad idea. All the triggers will be within the transaction so...

• This reply was modified 2 years, 9 months ago by Ken McKelvey.
• This reply was modified 2 years, 9 months ago by Ken McKelvey.

I am not sure about SSIS but, assuming your object is a DataTable, try SqlBulkCopy:

https://www.howtosolutions.net/2016/07/dotnet-save-datatable-into-database-table/

I am confused. You say you are using EFS which I would expect to be used by Linix but you then mention C: which would be used by Windows. I...

I have not needed to do this but can think of two options to get live Oracle data; neither of them are particularly appealing.

Option one:

1. Create web services to access...

Our network team have just installed their new backup system, called Cohesity, on one of our servers. It seems to work in a similar way to Datto. My backup routine...

• This reply was modified 2 years, 10 months ago by Ken McKelvey.

,ROW_NUMBER() OVER (ORDER BY datalc, cm desc) AS RowNum

Using the above on 20140812 the first cm (RowNum = 1) will be 98 so your rules make the...

• This reply was modified 2 years, 10 months ago by Ken McKelvey.

Seemed to double post

• This reply was modified 2 years, 10 months ago by Ken McKelvey.

For someone with a mathematical background, I do not think Joe...

Umm.... The OP has form. I would say that repeatedly not providing DDL and test data is poor etiquette.

https://learn.microsoft.com/en-us/sql/t-sql/language-elements/select-local-variable-transact-sql?view=sql-server-ver15#c-antipattern-use-of-recursive-variable-assignment

sql server - Comma separated results in SQL - Stack Overflow

Maybe I am misunderstanding something but why...

The text data type has been depreciated for sometime and the remarks in the following state that CHARINDEX cannot be used with image, ntext, or text data types.

https://learn.microsoft.com/en-us/sql/t-sql/functions/charindex-transact-sql?view=sql-server-ver16

I suspect...