Home Forums Data Warehousing Integration Services format of decimal RE: format of decimal

  • September 4, 2013 at 11:39 pm

    #1647577

    sqlfriends (9/4/2013)

    You are right, although I have some reason but I think maybe I should keep it consistent.

    A derived question, U use dt_numeric precision 38, scale 1, when I export I expect 0.5. but why it shows

    .5 the leading 0 is trimmed off.

    Any idea?

    Thanks

    0.5, 00.5, .5 and .50000 are all the same, numerically - the leading and trailing zeros are insignificant. Why does it matter?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.