I have a question about the code being posted:

So you run an update, and if no rows were updated (reading @@rowcount), then you do an insert. What happens if...

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

union all is what you need ... but not necessarily the way you were thinking about it

declare @Temptable table
    ( ID   ...

The whole retry loop could be removed in my opinion.  This is a basic upsert.  The variables used for flow of control are deterministic so the retry is not...

change the dynamic port to a fixed port - you can even set it to the current picked dynamic.

alternatively, and if you have this on a Domain, allow the AD...

so you are telling us that doing a

insert into archive_table
select *

from main_table where filtering_column = date_to_archive 

takes 5 minutes?

or that it takes that amount of time retrieving the...

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

you need to install ssdt-bi for 2013 - not the standard one.

https://www.microsoft.com/en-us/download/details.aspx?id=42313

but why are you still using 2013? you should be on the latest version or at least on 2017

you need to stop just asking your questions here and google first - plenty of links given for it including some from oracle and one of their tools to do...

Teaching a man to fish...That's pretty cool, Frederico.  Thanks for taking the time to post that.

If don't mind, I have one more question... what do you use to schedule...

Can you give us the ACTUAL explain plan, not the estimated one.

INSERT INTO @retTable
        SELECT c.ClaimID, cd.ServiceCode, c.ServiceDate, cd.ServiceQty, c.CareProviderID,...

you need to get back them and tell them if they wish to use the .conmgr file that means using SSIS Catalog and Environments and Configurations within the catalog as...

did you even bothered reading the manual?

https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkident-transact-sql?view=sql-server-ver15

interesting and a good example for SSIS - but does not catch all cases, neither addresses the real issue that is that the file was badly created and is therefore...

this may help you https://docs.microsoft.com/en-us/analysis-services/analysis-services-backward-compatibility

regarding multidimensional only mentions are that these 2 are deprecated

• Data Mining
• Remote linked measure groups

and these were discontinued

• Remote partitions
• Remote linked measure groups
• Dimensional...

I never did figure out why it would work in one place and then not installed on the server.   I'm still thinking there is potentially a permissions issue.   I...

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

code here instead of word doc - easier for most to see

one thing i would change is the fact that the code, if the record does not exist already, does...