Thank this author by sharing:
By Jacob Sebastian, 2010/10/04
TSQL Challenge 40 - Convert string representation of numeric values from binary to hexadecimal format.
This challenge involves converting numeric values from binary format to hexadecimal format. Your job is to process all the input rows from the source table and produce hexadecimal representation of the binary values.
http://beyondrelational.com/blogs/tc/archive/2010/10/04/tsql-challenge-40-convert-string-representation-of-numeric-values-from-binary-to-hexadecimal-format.aspx
Converts a binary SID to string format.
Multidimensional database internal representation.
This challenge invites you to write a query that converts binary values into decimal format.
Binary Data Conversion
Binary Data Type
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.
Join us!
Steve Jones Editor, SQLServerCentral.com
