You say this:

The database is intact and there is no error in it because it was working in copy (ٍَSQL server 2008)

which suggests that you were able to migrate the...

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