Post reply

Merging multiple row values to fewer rows

  • April 14, 2011 at 3:18 pm

    #249449

    Hi I need help with this issue..

    here is the sample of my data

    ReportDate ProcessSeq RevRsn Suspense Interest Escrow

    9/14/2010 8 30 3,670.77-

    9/14/2010 5 30 10,999.98-

    9/14/2010 2 30 12908.93

    9/14/2010 8 30 null 12873.51

    9/14/2010 5 30 null

    9/14/2010 2 30 null

    9/14/2010 8 null 3348.65

  • April 14, 2011 at 3:27 pm

    #1311888

    Please read this article, it explains it all: http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

    In addition to the DDL and DML please post the queries you have tried so far 🙂

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • April 14, 2011 at 3:32 pm

    #1311892

    I tried to use merge join and its not giving the results as I needed..

    and I am not so good at script to use script component...

  • April 14, 2011 at 3:41 pm

    #1311894

    Someone may correct me if they know of a better way in SSIS, but I think you're better off doing this work in T-SQL. Please read the article in my previous post.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • April 14, 2011 at 3:44 pm

    #1311896

    If you don't mind can you send me the link

  • April 14, 2011 at 3:47 pm

    #1311898

    saritha.gedela (4/14/2011)

    If you don't mind can you send me the link

    The link is in his first reply to you. It's the text in blue (usually).

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA

Viewing 6 posts - 1 through 5 (of 5 total)

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