Post reply

Copying column data from SSMS 2014 - how to get it to NOT format XML

  • April 10, 2018 at 1:37 pm

    #328278

    I have an issue when copying data from a results grid, to Excel, Ultra Edit, word, notepad, textpad, exporting the table, creating a .rpt file in SSMS.  No matter what I do or how I copy it, the data in one column gets put in standard XML format. I thought it was because of the data, but a co-oworker copying the same data results does NOT have this issue, so I think it is some option in my SMS somewhere.. but I cannot find it.

    the table has four columns:
    CREATE TABLE [dbo].[table_name](
        [ID] [numeric](9, 0) NOT NULL DEFAULT (0),
        [ITEM] [char](100) NOT NULL DEFAULT (' '),
        [PERSONALIZED_NAME] [varchar](60) NOT NULL DEFAULT (' '),
        [ITEM_DATA] [ntext] NULL
    ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

    and one row of  data (this is just copied right out of the results grid) 

    ID    ITEM    PERSONALIZED_NAME    ITEM_DATA
    3415    RateTablesList                                 Level 3    <page>
        <metadata>
            <base-name>RateTable</base-name>
        </metadata>
        <layout>
            <list>
                <fields>
                    <field name="PYR_GRADE"></field>
                    <field name="PYR_RATE_CODE"></field>
                    <field name="PYR_PAY_DED_CODE"></field>
                    <field name="PYR_DATE_EFF_ON"></field>
                    <field name="PYR_DATE_EFF_OFF"></field>
                    <field name="PYR_DESCRIPTION"></field>
                    <field name="PYR_AMT_RATE_3"></field>
                </fields>
            </list>
        <search><fields /></search></layout>
    </page>

    When my coworker copies this the exact same way she gets the data all on one line, like this:

    ID  ITEM  PERSONALIZED_NAME  ITEM_DATA
    3415  RateTablesList Level 3  <page><metadata><base-name>RateTable</base-name></metadata>.....

    Anyone have any ideas on what setting is controlling this?

    Thanks in advance!

  • April 11, 2018 at 2:21 pm

    #1986482

    Just to be sure, are you both copying into the same application?
    And if so, could it be a setting in that application?

    Just took a quick trip through SSMS settings and dont see anything either.

    Also, you listed "exporting the table" as one way that you moved the data and still did get the XML formatted result.
    How did you do this export? using what and to what type of file and what did you use to view what was exported?

    Sorry, nothing comes to mind but questions. 🙂

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

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