Post reply

Result in separate column?

  • February 13, 2014 at 9:28 pm

    #283712

    Hi,

    Result in separate column?

    I have data like one row (ab-xyz, bc-xyz, cd- xyz)

    I want output, how to split these two different columns in one single row data?

    Col1col2

    abxyz

    bcxyz

    cdxyz

    thanks

    ananda

  • February 13, 2014 at 10:49 pm

    #1688975

    You may try to use recursive CTE..

  • February 13, 2014 at 11:02 pm

    #1688979

    A string splitter such as the delimitedsplit8k that can be found here on SSC would be a good start if the data is concatenated into a single string. This would be to get the string into multiple rows.

    Then, the use of substring and maybe charindex could possibly help to get the results into two columns.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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