Mona,

the insert-update block does not do the update itself - just inserts the rows that need to be updated onto a a staging table, and then the "apply staged updates"...

you should then do yourself a favor and search for outer apply examples and study them.

they are incredibly powerful and know how to use them is a must for a...

something like this should do the trick.

the "allow" column returned by the SQL you only use for validation, and do not show on your page.

If for some reason for a...

we would need the explain plan file itself, not images of it.

Frederico your code works!

Apparently somebody pointed sources to linked server to PRODUCTION (Damn.. I think that's why i wasn't getting a match for  five days!..) And that's why function...

what are you trying to do now? the previous script you had was inserting into a SQL table - I gave you the base script for that.

This one seem to...

• This reply was modified 5 years, 9 months ago by frederico_fonseca.

while we are curious to see if the code is indeed doing what is supposed to do (Business rules may be correct) I decided to give an attempt at it...

I wonder if the query is really doing what you wish it to do or if there is a better way to do it.

first cross apply "explodes" the records -...

thanks for posting your attempt - didn't try to see if they had an error so apologies if what I'm posting looks similar

3 options - untested obviously as we don't...

• This reply was modified 5 years, 9 months ago by frederico_fonseca.
• This reply was modified 5 years, 9 months ago by frederico_fonseca.

and what have you tried so far? this is a pretty simple function that any SQL Developer should be able to replace with a CTE and outer applies

that is your problem - in order to use the command line you need to have SQL Server installed including Integration Services.

what is the error and are you running on a server or on your pc?

note that to run from the command line you need to have SQL Server Integration Services...

create the clustered index on the same partition schema - other indexes do not need to be on a partition but the clustered one does

yes.... at a high cost mind you.

see https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/use-hcc-this-service.html

and https://logicalread.com/2013/06/17/oracle-11g-hybrid-columnar-compression-mc02/

not for all versions of oracle

• This reply was modified 5 years, 9 months ago by frederico_fonseca.

its not as easy as that - and maxdop should always be set and not left at zero or 1 unless for a particular server that has been tested and...

• This reply was modified 5 years, 9 months ago by frederico_fonseca.