Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

TSQL Challenge 40 - Convert string representation of numeric values fr

By Jacob Sebastian,

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

 
Total article views: 1617 | Views in the last 30 days: 1
 
Related Articles
BLOG

SQL Server: Converting binary data to a hexadecimal string

Problem I have a requirement to convert the binary data inside a table column or variable to a he...

SCRIPT

Convert binary SID to string

Converts a binary SID to string format.

FORUM

Multidimensional database internal representation.

Multidimensional database internal representation.

SCRIPT

Convert integers/numbers into binary format - viceversa

This functions are used to convert integers/numbers into binary format and viceversa.

ARTICLE

TSQL Challenge 51 - Convert long Binary strings to Decimal strings

This challenge invites you to write a query that converts binary values into decimal format.

Tags
 
Contribute