Home Forums SQL Server 2005 T-SQL (SS2K5) Negative numbers...... RE: Negative numbers......

  • February 20, 2009 at 3:07 am

    #947381

    GilaMonster (2/20/2009)

    While it's not perfect, try using ISNUMERIC and see if there are any columns that it considers not numbers.

    Thanks GilaMonster.

    It is due to some nonnumeric data I believe. I am not sure where the problem is. Because There are 5000 records.

    The Min_Temp column values for some records is not null and an empty space. This might be the problem.

    I checked with ISNUMERIC and if it is true convert to float else null.

    Millions of thanks for your help. I become nervous because the live data is there and the total production affects if the transfer is not working properly.Thanks for your help.

    Thank You