Quick question, are you running the upgrade as Administrator? Is the Administrator a member of SQL sa?

😎

Further on the RGB to HEX conversion, it is simply working with 3 out of four octets in an integer, swapping octets 1 and 3, A12-B34-C56 becomes C56 B34-A12....

From the top of my head, something along these lines: disable SSIS, detach the SSIS database and then run the upgrade. After the upgrade you can migrate your SSIS to...

Quick note on the sys.fn_varbintohexstr function, DON'T use it, use CONVERT instead. A little while back I was working with a large set of MD5 checksums and the original code...

Brilliant as always Jeff!

Having had the first portion of my industrial strength espresso this morning it dawned on me that simple bit-bashing would do the job

😎

Reversing the byte order

DECLARE @COLOURINT...

With the integer you will have to reverse the byte order, here is a quick example

😎

DECLARE @COLOURINT INT = 14745599;

SELECT CHAR(35) + CONVERT(VARCHAR(6),SUBSTRING(CONVERT(BINARY(3),@COLOURINT,1),3,1) + SUBSTRING(CONVERT(BINARY(3),@COLOURINT,1),2,1) + SUBSTRING(CONVERT(BINARY(3),@COLOURINT,1),1,1),2)

Result

#FFFFE0

Hi Thomas,

here is a quick example of RGB triplet string into a hex conversion

😎

DECLARE @STRCD VARCHAR(11) = '255,128,255';

SELECT

CONVERT(VARCHAR(11),CONVERT(BINARY(1),CONVERT(INT,SUBSTRING(@STRCD,1,CHARINDEX(',',@STRCD)-1),0),0)

+ CONVERT(BINARY(1),CONVERT(INT,SUBSTRING(@STRCD,CHARINDEX(',',@STRCD) + 1,CHARINDEX(',',@STRCD)-1),0),0)

...

Quick suggestion, run a DIR before and after, the difference in the counts are the number of files deleted

😎

Is it simply blocking or is it dead-locking?

😎

A comic situation would be two threads trying to write to the deadlock file at the same time...:-D

laughing

Shark...

Digressing slightly, how would the threadizens describe the optimal code comments? Obviously the opposite of that would be the worst;-)

😎

Don't take this bad but being blatant and straight to the point, given the lack of quality and the level of naivety portrait in the code posted, I strongly recommend...

First a quick question, why the nolock hint? Are you running of a read only database? If the database is not read only then remove the nolock hints, re-run the...

Can you post the full code, ddl and some sample data please?

😎