Home Forums SQL Server 2014 Development - SQL Server 2014 a simple join RE: a simple join

  • May 19, 2015 at 12:51 pm

    #1799134

    Angel DBA Mex (5/19/2015)

    thanks SSC-Insane

    but already I´ve found the mistake, it is when the information has imported from a txt file, this has a special character, Char(13), Char(10), in this case only we replace these caracters with '' a space null

    Thanks again to all

    🙂

    People's names are actually above their avatar.

    FYI: CHAR(13) is a Line Feed and CHAR(10) is a Carriage Return. Common in txt files with more than one line. It appears that Lynn used the a Jedi Mind trick to help you with your issue.

    "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