Thank everyone for your kind and good advice! thanks so much!

Frederico .... maybe you're onto something.

Your query has multiple references to ftbid01 which obviously should be to 01, 02, 03, ...

The outer apply could be a cross apply, or...

if I got it correctly the dynamic requirement is that its not the content of the field that is being updated but rather that the field it is being...

Please kind see my...

It would be easier to give a complete answer with the Profiler events and filter. However, on a guess, the process id changed? They're not always the same. If...

Thanks Grant Fritchey!  The connection process ID wasn't changed, when I login system (C/S system), I check its process ID under windows task manager, and I didn't log out this...

thank you for your kind help!

Because your using string literals to represent a datetime format.

CONVERT(VARCHAR(6), '2020-09-23 00:00:00.000', 112)

The above is taking a string and converting it into a 6 character string.

Datetimes...

SELECT TableVariableTypeName = tt.name
     , ColumnName = c.name
     , ColumnNumber = c.column_id
    , [DataType] ...

thanks !

but  there are some parameters of actual execution plan such as cached plan size/Memory grant/Estimated subtree cost ...,

if we compare which sql statemest is better as the said sql...

hmm, I saw some books or article says the execution plan is inaccurate , if like this how we can compare which sql statement is better ?

I used actual execution...

thank you so much, Jo pattyn!

Sorry for my bothering !

How to calculate the RAM used while running a query, for example, I run the following code, how can I know the RAM used by this...

thanks eveyone in advance!

anyone can help me with my said questions, thanks!

Yes, thank you Mike and Jeff!