Post reply

SELECT a String

  • December 1, 2014 at 11:38 am

    #397715

    Hi I have string as below:

    InvoiceTemplateId= SOURCE.InvoiceTemplateId

    ,Name= SOURCE.Name

    ,DetailTotalUnitsQty= SOURCE.DetailTotalUnitsQty

    ,InsertedDate= SOURCE.InsertedDate

    ,UpdatedDate= SOURCE.UpdatedDate

    ,Distributor_Id= SOURCE.Distributor_Id

    ,InsertedBy= SOURCE.InsertedBy

    ,UpdatedBy= SOURCE.UpdatedBy

    I need a string Like below:

    Name= SOURCE.Name

    ,DetailTotalUnitsQty= SOURCE.DetailTotalUnitsQty

    ,InsertedDate= SOURCE.InsertedDate

    ,UpdatedDate= SOURCE.UpdatedDate

    ,Distributor_Id= SOURCE.Distributor_Id

    ,InsertedBy= SOURCE.InsertedBy

    ,UpdatedBy= SOURCE.UpdatedBy

    So I need every thing except the First value before first comma . So could some one help in TSQL .. Thanks in Advance

  • December 1, 2014 at 11:49 am

    #1761828

    Please stop posting the same thing in multiple forums!


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • December 1, 2014 at 11:57 am

    #1761831

    Answers in here:

    http://qa.sqlservercentral.com/Forums/Topic1640410-392-1.aspx

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • December 11, 2014 at 6:59 pm

    #1764255

    Seems to be a correct answer, as well. If it's not, let them know on that other post.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

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

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