modified version that solves that particular issue - previous one was really just addressing the parsing, not the accuracy of the output.

this version also addresses possibility of more than 99...

this will work as long as difference does not go past 31 days

SELECt RIGHT(CONVERT(varchar(19) -- always put the size when defining datatype - do not use defaults...

although going through the route of linked server best practices would mean that the linked server would not be named as the server name but rather as a logical name...

ahhhh... and issue is that its not only SQL developers that introduce "issues" like this.

A EF extension (https://github.com/borisdj/EFCore.BulkExtensions) built to make it easier for C# developers to do high speed...

although. 2 ms for a dynamic sql? how often is this executed during the day? unless it is being executed hundreds of times per minute I would not bother too...

not a rowbar as such - but it gives a nested loop operator.

but as your code is not the real one why don't you post what you really have -...

SSIS is not the best neither the most professional way to do it.

Most times SSIS should not be used at all, and it can be the source of the biggest...

do not use linked servers to push data to a SQL Server - it does so on a row by row basis.

always pull - or use a process outside SQL...

see this for edge https://stackoverflow.com/questions/57034199/integrated-windows-authentication-in-microsoft-edge

and this for chrome https://knowledge.kofax.com/Smart_Process_Applications_-_TotalAgility/Configuration/Configure_Chrome_To_Allow_Windows_Authentication_Without_Prompting

CONVERT(varchar, DecryptByKey([Password_Encrypted])) AS 'DecryptedPwd'

first - NEVER use any data type without specifying its type

decryptbykey returns a varbinary(8000) - so convert it to a varchar(8000) or varchar(max)

second - if the bytes...

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.