as you didn't read what I said, neither the link, please...

hum. based on the output you gave us you are executing a Sybase BCP command - so either you not using SQL Server or the server you are executing the...

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

can you post the code here - without it we can't tell you what you are doing wrong - but normally its a small thing like missing quotes somewhere.

possibly because it is a cluster and it has its own IP - which will be different from the local host (cluster node)

@Sergiy - for sake of consistency can you give your version (condensed) that gives both outputs I gave - and taking in consideration that either today or yesterday could be...

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...