Viewing 15 posts - 6,031 through 6,045 (of 8,761 total)
Quick suggestion, use TRY_CONVERT
😎
DECLARE @DATEVAR DATE = NULL;
DECLARE @STRVAR VARCHAR(50) = 'Not...
March 17, 2015 at 3:57 am
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
)...
March 16, 2015 at 11:22 pm
Quick possible solution/method, should give you an idea
😎
DECLARE @COLOURINT INT = 14745599;
SELECT 'RED' AS C_IDX, ( @COLOURINT & 0xFF) ...
March 16, 2015 at 1:19 pm
webrunner (3/13/2015)
Eirikur Eiriksson (3/13/2015)
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
Hello, thanks for...
March 15, 2015 at 2:31 pm
thomashohner (3/15/2015)
That Bit Bash is sweet! Wow, so cool. I'm not sure why this is exciting but it is. 😀
It is short, concise and straight to the point, nothing complex...
March 15, 2015 at 2:28 pm
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...
March 15, 2015 at 2:24 pm
Have you searched for the Detail.txt log file, my guess is that might lead to the reason for the setup failure?
😎
March 15, 2015 at 6:16 am
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...
March 15, 2015 at 6:07 am
Quick question, are you running the upgrade as Administrator? Is the Administrator a member of SQL sa?
😎
March 15, 2015 at 5:26 am
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....
March 15, 2015 at 5:20 am
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...
March 15, 2015 at 3:05 am
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...
March 15, 2015 at 1:21 am
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...
March 15, 2015 at 12:50 am
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
March 14, 2015 at 2:20 pm
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)
...
March 14, 2015 at 12:59 pm
Viewing 15 posts - 6,031 through 6,045 (of 8,761 total)