I'm in the process of converting two columns in two separate tables...
One column in Table A has a hexadecimal number (with a nvarchar data type) i.e. "A5000000020" and converting it to a decimal it should be "11338713661472"...
In Table B the column has a decimal number (with a bigint data type) i.e "1434519076864" and converting it to a hexadecimal the would make the value "9D500000005"
I keep getting stuck!!!
How can I successfully convert these columns?!
Thanks in advance!!!