Home Forums SQL Server 2008 T-SQL (SS2K8) Converting varbinary to numeric type in tsql -- decimal in c# RE: Converting varbinary to numeric type in tsql -- decimal in c#

  • June 27, 2013 at 9:41 am

    #1628040

    yeah i see that now;

    a simple test harness for others to use:

    ;With MySampleData([Name],[DecimalValue],[NumericValue])

    AS

    (

    SELECT 'Number2_4', 0x14E20100000000000000000000000200, 1234.12 UNION ALL

    SELECT 'Number1', 0xCF040000000000000000000000000100, 123.1 UNION ALL

    SELECT 'Number5', 0xD9299549000000000000000000000500, 12345.12345 UNION ALL

    SELECT 'Number4', 0xF24FBC00000000000000000000000400, 1234.1234

    )

    SELECT * FROM MySampleData

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!