Post reply

Merging two data fields from same data table

  • January 2, 2009 at 4:58 am

    #199560

    Hello,

    I have table text and 3 table fields:

    ID

    intro_text (ntext)

    main_text (ntext)

    I'd like to merge intro_text into main_text and merge all data that in this field (2000 records)

    If the data in intro_text is: "Any questions and discussions related specifically to SQL Server tools." and in main_text is: "For discussions on features exposed through tools, please post to the directly-related forum" I'd like to have only one field main_text with data: "Any questions and discussions related specifically to SQL Server tools. For discussions on features exposed through tools, please post to the directly-related forum". In intro_text is only text, there is not images or any another files

    Is there possibility to make this merging without making new database because I have 2000 records in text data table

  • January 2, 2009 at 5:26 am

    #920197

    Here's[/url] an excellent article which describes how to merge text/ntext datatypes.

    Cheers

    ChrisM

    “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

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply