Home Forums SQL Server 7,2000 Administration CAST CONVERT doesn't work RE: CAST CONVERT doesn't work

  • March 18, 2013 at 6:36 am

    #1598030

    walter.habegger (3/18/2013)

    Thank you both for your replies, as a result, I saw that all data of the source field where correct.

    I removed the .NET Framework 3.5.1 (KB2789645) and 4 (KB2789642) Updates.

    now it works.

    Thanks for your help, Walter

    Regarding both updates, Microsoft Support state the following:

    "Note We do not recommend that you remove any security update."

    I'd be very interested to see any documentary evidence that these updates affect CAST or CONVERT in SQL Server.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden