Thanks DesNorton  ...

Works really nicely and quick.

kaj,

I did try your solution it did seem to produce same results, but your saying

" All those inner joins with their individual criteria would...

Wow that seems very fast...

I'm not sure why some of this code exists and its logic wasn't up front when developed

Much appreciated for your reply.

I'll try to workup some dummy data... to load ...

any quick observations?

Thanks.

I ran into this issue using dbatools

WARNING: [09:31:34][Get-DbaDatabase] Failure | The certificate chain was issued by an authority that is not

trusted

Or could I put a loop and check it twice to validate switch?

Thanks.

Any ideas on how I can maybe put try\catch to make sure nothing is hanging up?

read-commited

Thanks Jeffrey..

Yes, I'll review the one with ID included. The script I posted above does archive the desired results. I was thinking that I could just issue

a Truncate after processing....

Okay thanks. this seems to perform the task at hand, but is there any way using the ID field to maybe multi-thread the process instead of RowByRow?

I'm using PS5.1

            
June 4, 2024 at 11:21 am
            
#4426104

            
            
                                                
        

Would it be any better if I dumped to .sql file from Source then Process that file on Target? Would it be any quicker?

How could I keep track of which...

In my original Post that's what I was trying to accomplish ..

Good catch, and thanks for your reply.

This is what I'm trying to accomplish.

The purpose of the script processes records from a table which is on a different server than where...

Thanks

Using exactly what you have above returns error:

Invoke-SqlCmd : A network-related or instance-specific error occurred while establishing a connection to SQL Server.

<><><><><>

If I change to this:

$sourceInstance = "localhost";

$sourceDatabase = "CB_SandBox";

$sourceQuery...

The sqltoexec contains statements that need to execute against:

$ServerInstance = 'at-sqltest'

$Database = 'Cost'

It contains Insert Into statements against a Table that exists in the COST(DB) over on another server(at-sqltest). The...

The data that's in field sqlToExec is from a Table on a different server that I'm applying too. This is where I'm applying too:

$ServerInstance = 'at-sqltest'

$Database = 'Cost'

I enclosed "Linked...