Converting Binary Numbers To Hex

A short piece looking at how you might convert binary numbers into hexadecimal in T-SQL.

T-SQL Decommenter Part III

Detailed explanation of the recursive section of the T-SQL Decommenter.

T-SQL Decommenter Part II

Demonstration of the T-SQL Decommenter removing comments from a sample T-SQL batch.

T-SQL Decommenter Part I

Introduction to a T-SQL query that remove comments from T-SQL code

Mixed Joins

Finding the Percentage

COLUMNPROPERTY in SQL Server 2016/2017

Conditionally Order By Different Column

Order records based on a different column depending on which absolute value is greater.

TRY_PARSE

Introducing the PARSE function, brought to us in SQL Server 2012.

T-SQL to compress (shorten) IPv6 address

Didn't find anything, so hope this will help someone with similar need.

Note I did a similar set-based version, and unless the input is more towards non-zeros in all eight 2-byte fields, the set-based performs not as well