DTS Help Needed Here - PLEASE READ!

DTS Help Needed Here - PLEASE READ!

Post by Paul Zil » Fri, 12 Jan 2001 01:20:04



Ok, here is my problem.

I have two tables.
Table One is a "master" table defined like this:
    master
        master_id        decimal
        child_id           decimal
        other_col1       varchar(10)
        other_col2       decimal

Table Two contains multiple rows of text for each row in "master" and is
defined like this:
    detail
        master_id        decimal
        child_id           decimal
        text_seq          decimal
        text                 varchar2(72)

In DTS I need to put those two tables together, joining by master_id and
child_id and concatonate all of the text columns for each match into one
column.  The destination table would look something like this:
    destination_table
        master_id        decimal
        child_id           decimal
        col1                varchar2(10)
        col2                decimal
        text                  varchar2(4000).

Example:
    master:
            master_id                child_id            col1
col2
                1                               1                XXX
543
                1                                2               YYY
32112

     detail:
            master_id       child_id            text_seq        text
                1                    1                        1
This is the first part and
                1                    1                        2
this is the second part
                1                    1                        3
and this is the last part.

    destination
            master_id        child_id    text
                1                    1            This is the first part and
this is the second part and this is the last part.

I hope I have given enough information and yet not too much information to
confuse.

Please assist.

Paul