Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    10

    Unanswered: Adding number of decimal places during table design

    Hello,

    Nice easy one (hopefully) from a newbie on SQL 2000.

    I have a table HolidayTakenBooked which is populated from a stored procedure via the following statement;

    TRUNCATE TABLE HolidayTakenBooked
    INSERT INTO HolidayTakenBooked
    SELECT * FROM #TMP_HolidayTakenBooked ORDER BY ABR_Clock_No

    I am finding that for certain values in the HolidayTakenBooked table decimals are not being transferred correctly. ie. 0.5 in the TMP table appears as 1 in the HolidayTakenBooked table.

    I'm pretty sure that this is down to the data definition of the table see sample field below;
    [HOL_DaysTaken1] [decimal](18, 0) NULL ,

    So the simple question here is how do I define decimal places when I define a new table. When designing a new table in Enterprise Manager I select decimal and the server does not allow me to change the value of 9 it defaults to.

    What simple thing I am not doing ?

    Cheers
    Neal

  2. #2
    Join Date
    Nov 2005
    Location
    San Francisco, CA
    Posts
    506
    Put values in Scale properties,you will find it just below precision if you are creating tables in EM design Table option...
    Success is the ability to go from one failure to another with no loss of enthusiasm.
    - Sir Winston Churchill
    Joydeep

  3. #3
    Join Date
    Jun 2004
    Posts
    10
    Many thanks.
    Neal

Posting Permissions

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