Home Forums SQL Server 2005 T-SQL (SS2K5) Calculating Yield RE: Calculating Yield

  • October 24, 2012 at 4:25 pm

    #1552464

    kabaari (10/24/2012)

    Below are my results:

    yield

    94.4000000000000000

    97.6000000000000000

    98.4000000000000000

    96.8000000000000000

    Now, I need to get rid of the zeros and show dates.

    You should do formatting on the front end.

    But if you must do it here, an easy way is

    CAST( yield AS decimal( 3,1))

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2