http://sqlblog.com/blogs/michael_coles/archive/tags/code/SQL/default.aspxTags: code, SQLenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/michael_coles/archive/2010/04/04/bit-twiddling-in-sql.aspxSun, 04 Apr 2010 03:40:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:24024Mike C4http://sqlblog.com/blogs/michael_coles/comments/24024.aspxhttp://sqlblog.com/blogs/michael_coles/commentrss.aspx?PostID=24024http://sqlblog.com/blogs/michael_coles/rsscomments.aspx?PostID=24024Someone posted a question to the SQL Server forum the other day asking how to count runs of zero bits in an integer using SQL. Basically the poster wanted to know how to efficiently determine the longest contiguous string of zero-bits (known as a run...(<a href="http://sqlblog.com/blogs/michael_coles/archive/2010/04/04/bit-twiddling-in-sql.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=24024" width="1" height="1">SQLSQL Servert-sqlSQL 2008set-basedexercisescodebit twiddling