Log in  ::  Register  ::  Not logged in

## Convert integers from decimal to binary display.

 Author Message David P Reynevich SSC Rookie Group: General Forum Members Points: 26 Visits: 36 Comments posted to this topic are about the item Convert integers from decimal to binary display. ron.mcdowell Grasshopper Group: General Forum Members Points: 14 Visits: 706 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 bitSELECT @BINval = CASE WHEN @INTval >= 0 THEN '0' ELSE '1' END + @BINval-- Voila...SELECT @BINval `