I would try and break it down into 2 (maybe 3) sql blocks by moving some of the "good plan joins" - those which have INNER joins - to a...

it can be answered - but its a tricky (misleading) question as it is trying to divert the question to a particular aspect, while the important point is another.

well... what Phil posted will remove the message - but the other way you may be using the isnull will not

so if you do the alternative to Phil's. where you...

and it takes 100 seconds to return 5.5 million rows TO WHAT CLIENT?? - if SSMS then the issue is likely not the query, neither the server but the simple...

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