ISO weeks start on a Monday so you might want to check this is okay.

This is a bad string splitting table valued function.

Use the following instead:

https://www.sqlservercentral.com/articles/tally-oh-an-improved-sql-8k-%e2%80%9ccsv-splitter%e2%80%9d-function

It all depends on how you define the week. You may want to use iso_week or have a table with your own definitions:

SELECT DATEPART(iso_week, '20210204'), DATEPART(week, '20210204');

I do this quite a bit with a powershell step in a sql agent job.

Something like:

$SQLparams = @{
  'ServerInstance' = '.';
  'Database' = 'YourDB';
 ...

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

First create some consumable test data which you should have provided:

CREATE TABLE #L
(
PK_POSTE int NOT NULL PRIMARY KEY
,NAME_POSTE varchar(20) NOT NULL
);
INSERT INTO #L
VALUES (1, 'Poste1'), (2, 'Poste2');

CREATE...

You can also setup a SQL alias:

https://www.mssqltips.com/sqlservertip/1620/how-to-setup-and-use-a-sql-server-alias/

I am still getting the error mainly on msdb. As I do not think anything is actually wrong I am ignoring it.

We use standard edition on Windows 2016 with VMWare.

Instead of:

CAST(t.Mass AS VARCHAR(3500))

try:

STR(t.Mass, 11, 5)

You may then want to look at getting rid of trailing zeros.

• This reply was modified 5 years ago by Ken McKelvey.

Try not to have spaces in object names.

Use three part naming convention.

MERGE will stop indeterminate updates by throwing an exception if there is more than one value.

MERGE...

• This reply was modified 5 years, 1 month ago by Ken McKelvey.

The transaction_isolation_level column in sys.dm_exec_sessions.

I am not sure how SSIS would cope with LineNumber of type identity. Maybe someone with more experience of SSIS can comment.

If you have the data in a text file...

If you have imported the LineNumber into SQL Server then everything should be fine.

If you had to resort to creating the identity column you should, as far as possible, verify...

Unfortunately in terms of relational database theory the rows are not next to each other as rows are unordered.

If the source of the rows is something like a CSV file...

Umm....

Let me try again.

A table is an unordered set so how do you tell what are the first two rows? (Obviously not the order you have listed them in as...

• This reply was modified 5 years, 1 month ago by Ken McKelvey.
• This reply was modified 5 years, 1 month ago by Ken McKelvey.

>the 1st 2 rows have all data for column 1-6 as it has row start with 2 and 3 below each other

What do you mean by the first two rows?

How...