option 3 - but with addition of fields

• time created -- used to determine how long it has been identified as an issue
• validated by
• validated date
• validation status (ok/not...

hum. should not be that slow but possible if the records are big - what's the file size?

is it possible to share the file (even if on private) for me...

as most of the features that were Enterprise only on 2008 are now standard featured I would just try and restore the db onto a 2017 standard edition - if...

try this function https://github.com/RamblingCookieMonster/PowerShell/blob/master/ConvertTo-FlatObject.ps1

most likely you may be able to do

[xml]$file =get-content $tempfile

$datatable = convertto-datatable -inputobject (ConvertTo-FlatObject -InputObject $file)

it needs to be all in same line - based on your output you have the sqlcmd in one line then the server name on a new line.

no update would not be like that - but as said you do not need to do the update.

update ca1
set ClientNotes = replace....
from ClientDetails as ca1

but that...

• This reply was modified 4 years, 7 months ago by frederico_fonseca.

Common is likely because it can be used anywhere on the same query multiple times unlike a derived table/subquery.

why do you need to remove them to extract them?

surely you are extracting into a properly defined CSV file and if so that does not matter - unless  you are...

no benefit - Express will use a maximum of 1 GB for database engine

https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/cc645993(v=sql.105)?redirectedfrom=MSDN

question is incorrect - but I guessed what you wanted.

I think that even you are capable of doing a "update t set firstname = 'xxxx' from mytbl" without the need to give you examples from the net.

if the application is going to remain active (or while it remains active until its usage/data is migrated to another application) I would leave it on its own database -...

you changed something on your script as the output you had given before meant the script supplied by Scott worked.

you may have dropped 1 column from the table definition (or...

stored procs is the easiest and fastest to implement for a small scale like that.

restore prod db to another instance (protected), run data desensitization process, backup and make backup available...

WHAT!!!!!!

Non Prod SHOULD NOT have PII information.

Get your processes changed so dev gets a version of the prod database that has gone through a process of removing PII information from...