Here is a version with a sequence number which you should be able to adapt

DROP TABLE IF EXISTS #Leave;

CREATE TABLE #Leave
(
    EmployeeId INT
 ...

The sample data you have provided has no column which provides ordering. Without a column to order by, a T-SQL solution is not possible.

Compare the execution plans in both environments. Are they identical?

Are the hardware, o/s and SQL Server versions the same?

Have you checked for blocking?

Does your view definition include 'WITH SCHEMABINDING'?

Thanks Jeffrey, I'd forgotten that CONCAT_WS() even existed.

Is this the extension which you are trying to add?

https://learn.microsoft.com/en-us/sql/ssdt/release-notes-ssdt-2019?view=sql-server-ver16

SELECT CONCAT(Col1,';',Col2,';',etc etc)

Simple and clear, quite impressive. Thanks for posting back.

If you believe this to be a valid and comprehensive response to my request,...

I think I'd switch the logic around a bit.

1. Does filename exist in table2?

   1. Yes – throw an error
   2. Else continue

2. Truncate staging table
3. Import filename to staging table
4. Execute...

Please be more specific than 'it doesn't work'.

We don't have access to your data, nor do we understand the underlying logic behind your query.

If you can provide some sample data,...

Time for me to check this out. As usual, there was an age between the release of VS2022 and its SSIS extension.

Or maybe not! It's still in preview and looks...

Your post raises some interesting points.

I can only take the senders word for it.

I wouldn't, but your way leads to an easier life!

Would you be prepared to share the code...

The FORMAT() function performs notoriously poorly. If you are processing a lot of data, I suggest you remove it and find another way (either in code, or using Excel or...

It may be an integer-division issue.

Try multiplying by 100.0 first, to force a decimal calculation:

Successful Picks * 100.0 / Total Picks

Note also that you have misspelled 'successful'.