Dennis Jensen, your positivity is impressive and laudable. But the definition of insanity as "doing the same thing repeatedly and expecting a different outcome" (wrongly attributed to Einstein) is applicable...

Sorry, I can't help you with this question, but I do admire the accuracy of your approximation!

Thank you to Ken and pietlinden for your support.

Okay Phil Parkin criticizing a questioner is poor etiquete. Instead if you feel their question needed more information simply state that without being condescending....

My query finds Min and Max to determine Lag, but I need to find the lastest Shipdate date(max) and then previous shipdate to determine lag  --> remove the Min(shipdate).

I...

Does the antivirus software you use have a CLI?

You could write a script task in C#, VB.Net to interact with your AV and call it to scan the file...

That is not easy! This gets you part of the way, but the MultiValue bit is missing:

DROP TABLE IF EXISTS #XML_TABLE;

CREATE TABLE #XML_TABLE
(
    ProductID...

It's difficult to help without seeing the actual execution plan and the DDL for StockDB (assuming that is a table rather than a database!)

For a quick fix, try the divide...

The database was working on copy (SQL server 2008) and now it is not working  on copy (SQL server 2014) and I get error number (0xc0202009)

Please explain what you mean...

The synonym suggestion avoids the...

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?