have a look at the function on last post from Steve (sgmunson) at https://www.sqlservercentral.com/forums/topic/how-can-convert-hex-value-to-decimal-in-sql-server-2012

based on the 100k row limit I would nearly bet this is to generate files to load to a MySQL Instance using the "Load data Local" statement (this is the...

while still putting emphasis on what Jeff stated with regards to company data on a local PC I am still supplying what I consider would be the better approach to...

according to your where clause the output is right - so maybe you only interested on the rows where both start and end time are between your filter?

something like (starttime...

I would nearly bet that the QC server does not have the SPN's set or that the connection to that server is not being done using kerberos (thus being unable...

open the file with a hex editor and see what the values are - likely they are (were) in a codepage that you aren't using and therefore it seems wrong.

put...

CXPACKET is not bad on its own - it may only be an indication that some queries are going parallel when they don't need/or could work better serially.

so those cxpacket...

I called him out on the fact that he had 4 threads asking exactly the same thing - he didn't like it

https://www.sqlservercentral.com/forums/topic/ssrs-rendering-format-excel-change -- I made the comment on...

I called him out on the fact that he had 4 threads asking exactly the same thing - he didn't like it

https://www.sqlservercentral.com/forums/topic/ssrs-rendering-format-excel-change -- I made the comment on this one

https://www.sqlservercentral.com/forums/topic/changing-excel-download-rendering-format

https://www.sqlservercentral.com/forums/topic/changing-the-excel-rendering-format

https://www.sqlservercentral.com/forums/topic/change-excel-download-column-format-to-text

regarding https://www.sqlservercentral.com/forums/topic/writing-a-line-for-each-day-of-month

can someone post a link to an older thread the OP created that does what it's asking (again) to be given to them.

older thread is https://www.sqlservercentral.com/forums/topic/how-do-i-write-a-record-for-each-day-in-a-date-range

I can't reply as...

anyone has any ideas regarding this https://www.sqlservercentral.com/forums/topic/deadlock-related-to-autocreateqpstats

its the standard sql 2012 spam - next post from the OP will be a "i got this" with a spam link

you talking about power bi report server on prem or Power Bi service on cloud? if on prem scheduling is the same as with SSRS (PBIRS is a superset of...

dup post - see replies in https://www.sqlservercentral.com/forums/topic/bulk-insert-problem-for-cav-file-2

without you giving us the sp and the exact lines where it is happening we can't really help you other than telling that the most obvious error is that your...