the correct answer always works correctly - and it is...

stop playing with copying the data and focus on getting the filtering correct.

maybe the column you are using isn't the right one to use - maybe it is only in...

bump for 2nd page issue

your issue is that while you are checking the variables against @maxid on the loop, you aren't checking it on the where clause - so you can get up to...

you don't change the system generated SP - what you do is setup a custom SP and register it to be used instead of the default one that is generated...

one option is to use Translate

see https://portosql.wordpress.com/2020/01/13/retirando-acentuacao-translate/ - option 2.4

tell your IT that you need to have a technical answer from the vendor - or that they need to block their IP (or do it yourself if you can)...

https://blog.sqlauthority.com/2018/08/08/sql-server-fix-error-17836-length-specified-in-network-packet-payload-did-not-match-number-of-bytes-read-the-connection-has-been-closed/

also have a look at this in case Docker is being used - or if it is related to encryption protocols.

https://github.com/microsoft/mssql-docker/issues/478

and you really should go to the vendor with this...

and fix  your data - these 2 look like they should be different db's

A DB2 1143 12/1/2023

A DB2 10110 6/1/2023

and make it clear if this are daily entries or monthly...

look at the convert link given about and use the format you need.

and why do you need that particular format on...

did you install it on the SERVER? or just your local PC?

and did you install the same "bit" version of the drivers as your SQL instance? if server is 64...

have you ensured to see if TCP is enabled as a protocol on the SQL Server Configuration Manager

and are you sure there are no firewall rules preventing you from accessing...

you have already been given an answer on your original thread https://www.sqlservercentral.com/forums/topic/txt-file-pipe

page bump

very very disappointed at this unholy situation. How is it possible that Jeff is wrong!!!!