Convert integers from decimal to binary display.

• David P Reynevich

  Old Hand

  Points: 398

  More actions

  October 8, 2007 at 2:12 am

  #180054

  Comments posted to this topic are about the item Convert integers from decimal to binary display.

• ron.mcdowell

  SSC Enthusiast

  Points: 172

  More actions

  May 18, 2011 at 7:48 am

  #1326455

  Here is the result of my Convert-Loop-To-Tally exercise:

  /* Convert signed integer to binary notation: */

  DECLARE @BINval CHAR(39) = ''-- Format: 'xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx'

  ,@INTval INT = 2147483647-- Positive limit

  --,@INTval INT = -2147483648-- Negative limit

  SELECT @BINval = CASE WHEN @INTval & power(2, N) > 0 THEN '1' ELSE '0' END/* Determine bit value */

  + CASE WHEN N%4 = 0 THEN ' ' ELSE '' END/* Blks of 4 bits each */

  + @BINval

  FROM [dbo].[Tally] WITH (NOLOCK)

  WHERE N BETWEEN 0 AND 30 /* Set all but sign bit */

  --ORDER BY N /* My tally tbl PK is N */

  -- Add sign bit

  SELECT @BINval = CASE WHEN @INTval >= 0 THEN '0' ELSE '1' END

  + @BINval

  -- Voila...

  SELECT @BINval