Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Keith Henry Filtering data using float column RE: Filtering data using float column

  • April 29, 2010 at 9:22 am

    #1159800

    Still not sure what the problem is... your example works just fine:

    DECLARE @tbl TABLE

    (

    DATE DATETIME,

    amount DECIMAL(10,2),

    interest FLOAT

    )

    INSERT INTO @tbl

    SELECT '2009-04-10 00:00:00.000', 450.00, 00.23 UNION ALL

    SELECT '2009-04-10 00:00:00.000', 451.00, -1.20 UNION ALL

    SELECT '2009-04-10 00:00:00.000', 460.00, 2.5

    SELECT DATE, amount, interest FROM @tbl WHERE interest > 0

    /* result set

    dateamountinterest

    2009-04-10 00:00:00.000450.000,23

    2009-04-10 00:00:00.000460.002,5

    */


    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]