Home Forums SQL Server 2008 SQL Server 2008 - General create YTD in a Table RE: create YTD in a Table

  • September 5, 2012 at 12:31 pm

    #1534066

    CELKO (9/5/2012)

    we do not use FLOAT in SQL because of rounding errors and the laws concerning currency.

    You keep saying this, but I work (and have worked) with multiple companies that do use FLOAT (and use it quite well) because the other data types don't give them the information they need. The waste management industry, for instance, needs it to calculate tonnage and other items.

    Some people even use FLOAT for financial transactions.

    So I have two questions for you.

    1) Who is "we"?

    2) What currency laws are you referring to? Because if I'm breaking laws by supporting these databases, I'd really like to know before I end up in jail for the rest of my life.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.