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

    Unanswered: Adding number of decimal places during table design


    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 ?


  2. #2
    Join Date
    Nov 2005
    San Francisco, CA
    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

  3. #3
    Join Date
    Jun 2004
    Many thanks.

Posting Permissions

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