Home Forums SQL Server 2005 SQL Server 2005 General Discussion query problem RE: query problem

  • February 19, 2015 at 7:38 pm

    #1778833

    Anything that is not in the form of: xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx where x is a hexadecimal value (e.g. 0-9 A-F) is going to fail... are c.evs_OrderIDid and b.ORdernumber formatted like that?

    why do you need to make this conversion? Seems odd that you would need to do that...

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001