Well, the consignment no. is the unique link on all the tables.

Hi Steve,

I still get replication when I do this. Is there a way I could control this ?

Hi Steve,

For rows that don't have the consignment number using the INNER JOIN will leave them out. How can I get around that ?

Thanks Todd.

The update values are dynamic and not fixed as such.

Hey,

How can I provide the table creation and sample data scripts ?

Regards,

Any news on this ?

Sure !

Great Question Sachin,

When you have multiple instances of 'S' this is what the data should look like

itemcode qty treetype linenum

...

Find files attached.

Cheers !

Dear Experts,

What I actually request for is a way to create some kind of grouping for the data into a hierarchical structure where the S elements are the parents and...

Thanks, but what does the part :- 'for insert not for replication mean'. On which table is the trigger on ?

Dear Hardik,

Sorry for the late reply. Thanks a lot for your query, it worked well.

Kind Regards,

Hardik,

The OITM table is not that important in this. You may actually leave it out.

Kind Regards,

Find attached TXT files with the actual data. Does this suffice for an import ? If not please tell me what to do.