Post reply

script task in sql server

  • June 20, 2009 at 2:57 am

    #132022

    i have a varibale defined inside script task as x=1.239876

    Now, i want to display only 1.23 and not 1.24(this is rounded)

    How do i do that?

  • June 20, 2009 at 5:35 am

    #1012803

    Please have at look at BOL (BooksOnLine), section "ROUND function", sub section "C. Using ROUND to truncate".

    Just out of curiosity:

    Is it a coincidence having almost the identical question on this post http://www.sqlservercentral.com/Forums/FindPost738765.aspx or is it you just with a different nickname?


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply