InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 18:15:29 GMT20http://www.sqlservercentral.com/Forums/Topic1073966-356-1.aspxMost people submit their solutions in the first two weeks after the challenge is published. The evaluation then might take another 2-4 weeks to complete. The solutions will be available publicly after the evaluation is completed. I would encourage you to go to [url=http://beyondrelational.com/puzzles/sqlserver/tsql/51/submit.aspx]http://beyondrelational.com/puzzles/sqlserver/tsql/51/submit.aspx[/url] and submit your solution.Mon, 07 Mar 2011 08:51:13 GMTjacob sebastianhttp://www.sqlservercentral.com/Forums/Topic1073966-356-1.aspxNot able to reach the site with the link provided the Site. The answer could be ;WITH CTEAS( SELECT SEQ, BINARYVALUE, 0 AS EXPO, CONVERT(NVARCHAR(4000),RIGHT(BINARYVALUE,1)) REMAINING , CONVERT(NVARCHAR(4000),LEFT(BINARYVALUE,LEN(BINARYVALUE) - 1)) DEDUCTIBLE FROM TC51 UNION ALL SELECT SEQ, BINARYVALUE, EXPO + 1, CONVERT(NVARCHAR(4000),RIGHT(DEDUCTIBLE,1)) ,CONVERT(NVARCHAR(4000),LEFT(DEDUCTIBLE,LEN(DEDUCTIBLE) - CASE WHEN LEN(DEDUCTIBLE) &gt; 0 THEN 1 ELSE 0 END )) DEDUCTIBLE FROM CTE WHERE LEN(DEDUCTIBLE) &gt; 0)sELECT SUM(remaining * power(CONVERT(NUMERIC(18,0),2),expo)),seq, binaryvalueFROM CTEgroup by seq, binaryvalueorder by seq, binaryvalueIf there is any better method, please let me know how can I view it?Mon, 07 Mar 2011 08:03:36 GMTsample1http://www.sqlservercentral.com/Forums/Topic1073966-356-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/T-SQL+Challenges/72253/">TSQL Challenge 51 - Convert long Binary strings to Decimal strings</A>[/B]Mon, 07 Mar 2011 00:05:16 GMTjacob sebastian