Post reply

multiple records into single record

  • July 31, 2013 at 8:33 am

    #278158

    I have a task, here in my table I have mutiple records for single icn that means each record is different by its detail line level information about that icn. As this is health care data, now my task is to keep all the detail level information of a particular icn into single record.

    The thing is for example:

    icn =1 may have 10 records

    icn =2 may have 20 records

    not all icn will have the same number of records.

    so how can I create a single chunk or record of a particular icn(where ten records should come in single record)?

  • July 31, 2013 at 8:49 am

    #1637415

    Welcome to the forum!

    Before we can help you, you really need to read and follow these tips when posting questions:

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

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

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