Post reply

how to concatinate of Column in a Single row.

  • January 12, 2011 at 4:43 am

    #230029

    Hi Expert .i want to concatinate Col C according to the Col A And Col B.

    Below here the data is available

    --------------------------------------------------------

    Coulmn A Col B Col C

    7600410Training Course in Secretarial Skills from Sustainable Developmet Institute, Islamabad

    7600410Diploma ub Word Perfect from Petroman

    7600410Diploma ub Word Perfect from Petroman

    760043B.A.

    -------------------------------------------

    I need the result in this shape. is there anyone who can write for Query for this particular scenario..please help me out

    ------------------------------------------

    Coulmn A Col B Col C

    7600410Training Course in Secretarial Skills from Sustainable Developmet Institute, Islamabad ,Diploma ub Word Perfect from Petroman ,Diploma ub Word Perfect from Petroman

    760043B.A.

    Regards

  • January 12, 2011 at 4:50 am

    #1272285

    You've got good timing. An article[/url] was just published today that covers this for you.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • January 12, 2011 at 10:28 pm

    #1272807

    Thank you very Much it will help me a lot..

    thanks Again.....

  • January 13, 2011 at 2:51 pm

    #1273299

    This might be helpful too !

    http://www.sqlservercentral.com/Forums/Topic1029409-1550-1.aspx

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

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