Professional Web Applications Themes

Convert - Microsoft SQL / MS SQL Server

I need to convert this example in 16 decimals number. CREATE TABLE #TMP_APLICACAO ( [VL_APLICACAO] [MONEY], [NR_QUANTIDADE] [NUMERIC] (28,16), [VL_PU_OPERACAO] [NUMERIC] (28,16) ) declare vl_pu_operacao numeric(28,16) INSERT INTO #TMP_APLICACAO VALUES ( 3103.40, 3.00, 0) select vl_pu_operacao = VL_APLICACAO / NR_QUANTIDADE FROM #TMP_APLICACAO SELECT VL_PU_OPERACAO PS. How can I have to do to see the result in 16 decimal number : 1034.4666666666666667 ? DROP TABLE #TMP_APLICACAO...

  1. #1

    Default Convert

    I need to convert this example in 16 decimals number.

    CREATE TABLE #TMP_APLICACAO
    (
    [VL_APLICACAO] [MONEY],
    [NR_QUANTIDADE] [NUMERIC] (28,16),
    [VL_PU_OPERACAO] [NUMERIC] (28,16)
    )

    declare vl_pu_operacao numeric(28,16)

    INSERT INTO #TMP_APLICACAO VALUES ( 3103.40, 3.00, 0)

    select vl_pu_operacao = VL_APLICACAO / NR_QUANTIDADE FROM #TMP_APLICACAO

    SELECT VL_PU_OPERACAO

    PS. How can I have to do to see the result in 16 decimal number :
    1034.4666666666666667 ?

    DROP TABLE #TMP_APLICACAO


    Marco Guest

  2. #2

    Default Convert


    select vl_pu_operacao = CONVERT(decimal
    (28,16),VL_APLICACAO / NR_QUANTIDADE) FROM #TMP_APLICACAO

    HTW
    Rajesh Peddireddy
     
    FROM #TMP_APLICACAO 
    number : 
    Rajesh Guest

  3. #3

    Default Convert

    I need to convert this example in 16 decimals number.

    CREATE TABLE #TMP_APLICACAO
    (
    [VL_APLICACAO] [MONEY],
    [NR_QUANTIDADE] [NUMERIC] (28,16),
    [VL_PU_OPERACAO] [NUMERIC] (28,16)
    )

    declare vl_pu_operacao numeric(28,16)

    INSERT INTO #TMP_APLICACAO VALUES ( 3103.40, 3.00, 0)

    select vl_pu_operacao = VL_APLICACAO / NR_QUANTIDADE FROM #TMP_APLICACAO

    SELECT VL_PU_OPERACAO

    PS. How can I have to do to see the result in 16 decimal number :
    1034.4666666666666667 ?

    I use select vl_pu_operacao = CONVERT(decimal
    (28,16),VL_APLICACAO / NR_QUANTIDADE) FROM #TMP_APLICACAO
    , but the results is 1034.4666666666 and itīs wrong.

    DROP TABLE #TMP_APLICACAO




    Marco Guest

Similar Threads

  1. Convert PDF to GIF
    By Jay_Shakir@adobeforums.com in forum Adobe Acrobat SDK
    Replies: 2
    Last Post: October 11th, 12:07 AM
  2. Convert pdf to xml using C#?
    By andrew.yoder@gmail.com in forum Adobe Acrobat SDK
    Replies: 1
    Last Post: January 30th, 09:22 PM
  3. Convert FLV to wav or MP3
    By kake76 in forum Macromedia Flash Flashcom
    Replies: 2
    Last Post: September 24th, 09:47 PM
  4. pls help convert
    By Tony Wilson in forum PHP Development
    Replies: 1
    Last Post: August 27th, 09:35 PM
  5. Do I need to Convert with Convert.ToInt32(session("myNumber")) ?
    By Andreas Klemt in forum ASP.NET General
    Replies: 1
    Last Post: July 23rd, 02:59 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139