Scott's synonym suggestion sounds like your best bet to me.

The output you get from your query is the same as

SELECT 'MERGE ' + dc.ChannelReadingTableName + ' USING ' + dc.MainLevelDataTableName
FROM #DeviceChannel dc;

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