question

fozzy767 avatar image
fozzy767 asked

Is there a way to do HEX2DEC in SSRS 2008?

Hello I am working with SSRS 2008. I am wondering if there is a way to do HEX2DEC. I have tried a few things but they get error out. I have tried using HEXTOINT and just HEX.
ssrs-2008
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image Fatherjack ♦♦ commented ·
can you give us some sample data, the error you are getting and the results you want to see?
0 Likes 0 ·

1 Answer

·
ThomasRushton avatar image
ThomasRushton answered
Try this: SELECT CONVERT(BIGINT, 0x12345678) There are some other options at http://blog.sqlauthority.com/2012/07/26/sql-server-answer-how-to-convert-hex-to-decimal-or-int/
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.