InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 02:06:38 GMT20http://www.sqlservercentral.com/Forums/Topic407886-870-1.aspxHere is the result of my Convert-Loop-To-Tally exercise:[code="sql"]/* 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) &gt; 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 &gt;= 0 THEN '0' ELSE '1' END + @BINval-- Voila...SELECT @BINval [/code]Wed, 18 May 2011 07:48:39 GMTron.mcdowellhttp://www.sqlservercentral.com/Forums/Topic407886-870-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/T-SQL+Aids/31604/">Convert integers from decimal to binary display.</A>[/B]Mon, 08 Oct 2007 02:12:17 GMTDavid P Reynevich