Results 1 to 12 of 12
  1. #1
    Join Date
    Jul 2003
    Posts
    55

    Angry Unanswered: Formating results in Query Analyzer

    I have a table as follows:
    A NO Balance [decimal (16,5)]
    ---------------- -------------------------------------------------- ------------------
    18.00 001000000000000 -37.982
    19.00 002000000000000 -17.656


    In the Query analyzer when I try:
    SELECT * FROM TABLE1

    A NO Balance [decimal (16,5)]
    ---------------- -------------------------------------------------- ------------------
    18.00 001000000000000 -37.98
    19.00 002000000000000 -17.66

    I need the query analyzer to format them as they are in the tables.
    Help please.

  2. #2
    Join Date
    Nov 2003
    Location
    FRANCE
    Posts
    393

    Re: Formating results in Query Analyzer

    it's weird
    it's if you round up the balance data

    try this

    select convert(decimal(16,5),balance)

  3. #3
    Join Date
    Jul 2003
    Posts
    55

    Re: Formating results in Query Analyzer

    Did not work! Same results!!!



    Originally posted by Karolyn
    it's weird
    it's if you round up the balance data

    try this

    select convert(decimal(16,5),balance)

  4. #4
    Join Date
    Nov 2003
    Location
    FRANCE
    Posts
    393

    Re: Formating results in Query Analyzer

    are you sure that Balance is really stored as -37.982

  5. #5
    Join Date
    Jul 2003
    Posts
    55

    Re: Formating results in Query Analyzer

    Yes, I am sure

    Originally posted by Karolyn
    are you sure that Balance is really stored as -37.982

  6. #6
    Join Date
    Nov 2003
    Location
    FRANCE
    Posts
    393

    Re: Formating results in Query Analyzer

    what is you're max precision ?

    SELECT @@MAX_PRECISION

  7. #7
    Join Date
    Jul 2003
    Posts
    55

    Re: Formating results in Query Analyzer

    38.0


    Originally posted by Karolyn
    what is you're max precision ?

    SELECT @@MAX_PRECISION

  8. #8
    Join Date
    Nov 2003
    Location
    FRANCE
    Posts
    393

    Re: Formating results in Query Analyzer

    where do you see the data -37.982
    ???

  9. #9
    Join Date
    Jul 2003
    Posts
    55

    Re: Formating results in Query Analyzer

    From the Enterprise Manager


    Originally posted by Karolyn
    where do you see the data -37.982
    ???

  10. #10
    Join Date
    Nov 2003
    Location
    FRANCE
    Posts
    393

    Re: Formating results in Query Analyzer

    SET NUMERIC_ROUNDABORT on
    SET ARITHABORT ON

    SELECT * FROM TABLE1


    does an error occur ???


    are you REALLY only doing Select * from Table1 ???

  11. #11
    Join Date
    Jul 2003
    Posts
    55

    Re: Formating results in Query Analyzer

    No error occured,
    I am sure 100% that I am doing only a select *!!


    Originally posted by Karolyn
    SET NUMERIC_ROUNDABORT on
    SET ARITHABORT ON

    SELECT * FROM TABLE1


    does an error occur ???


    are you REALLY only doing Select * from Table1 ???

  12. #12
    Join Date
    Nov 2003
    Location
    FRANCE
    Posts
    393

    Re: Formating results in Query Analyzer

    try contacting BlindMan or Breitt Keiser

Posting Permissions

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