Post reply

how write split function for this store procedure

  • January 30, 2012 at 12:41 am

    #1439854

    for this table only i want split function

  • January 30, 2012 at 10:11 am

    #1440125

    er.sivaganesh (1/30/2012)

    i posted the details

    Gosh... I understand the details on the table side. What does the delimited parameter you're passing or the CSV column that you're trying to split look like? Specifically, I mean what does the actual data within such a thing look like?

    For example, does it look like this?

    '1,2,3,4'

    or does it look like this where you're passing more than one row of information in the same parameter?

    '1,2,3,4,5,6,7,8'

    This is actually a pretty easy problem to solve using the split function that everyone has already posted a link to. I just need your particular details of the inputs so I can give you the code you actually need. Help me help you.

    --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)

  • January 31, 2012 at 12:17 pm

    #1440898

    i found the solution for my problem anyway thank u every one for sending our valuable time for me

  • January 31, 2012 at 3:04 pm

    #1440985

    er.sivaganesh (1/31/2012)

    i found the solution for my problem anyway thank u every one for sending our valuable time for me

    Thats nice. Two way street here, though... could you post your solution so we can have a look at it? Thanks.

    --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)

Viewing 4 posts - 16 through 18 (of 18 total)

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