'Get to the last record' still makes no sense to me. Once again, I suggest you provide the output you are hoping for.

I want to get to the last record

but i thinik ive...

Not sure what you mean by 'Complete at the last record'. What results are you hoping to see?

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...