Quick suggestion, use TRY_CONVERT

😎

DECLARE @DATEVAR DATE = NULL;

DECLARE @STRVAR VARCHAR(50) = 'Not...

As Dwain mentioned there are several ways of doing this, here are few examples

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.Transactions') IS NULL

BEGIN

CREATE TABLE [dbo].[Transactions](

[ID] [char](5) NOT NULL,

[Amount] [float] NULL,

[InjectedDate] [datetime] NULL

)...

Quick possible solution/method, should give you an idea

😎

DECLARE @COLOURINT INT = 14745599;

SELECT 'RED' AS C_IDX, ( @COLOURINT & 0xFF) ...

webrunner (3/13/2015)

Hello, thanks for...

It is short, concise and straight to the point, nothing complex...

Jeff Moden (3/15/2015)

Speaking of "brilliant", nicely done, Eirikur! Heh... you really put the hex on that problem. There's only 1 in 10000 people that would know something like...

Have you searched for the Detail.txt log file, my guess is that might lead to the reason for the setup failure?

😎

Apologies for not being of a much help so far.

😎

Quick thought, is side by side installation an option, that is installing the 2K12 on the same server, migrate every thing...

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)

...