Home Forums SQL Server 2008 SQL Server 2008 - General Error turning Varchar into Numeric RE: Error turning Varchar into Numeric

  • December 7, 2010 at 5:40 am

    #1259473

    I'm expecting some non-numeric values in [QR_FreeText] for [BSU_MarketSector]='M'.

    It seems like query optimizer decides to filter on [BSU_MarketSector] [QR_FreeText] first, therewith ignoring the invalid column values of [QR_FreeText].

    The article Chris mentioned can be found here.

    Use the method described in the article above to find the values that cannot be converted into bigint.


    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]