Thank you all for your suggestions. We are using Schemas for another different reason. We will go with the "TableNameStaging" convention.

Phil Parkin (12/19/2013)

---

chaseurpuli (12/18/2013)

---

Thanks for your reply Phil. Unfortunately, the...

Thanks for your reply Phil. Unfortunately, the destination table is...

Koen Verbeeck (12/17/2013)

---

I would read the head as it were data and concatenate the values in a script component.

One question though: why do you need to fiddle around with the...

@sergiy - Your code is good as long as the dates of the parents are different. If the dates of parents are same, the code is failing in...

@mickyT - your code works great. Thanks a lot.

@celko - I respect your experience and expertise. I am not a great programmer and I am not writing any books. I didn't work in ANSI/ISO SQL Standards...

@celko - Thank you for your response and vluable suggestions. I don't see CONVALESCE function either. I am not familiar with ISO-11179 data element conventions. I just gave...

Thanks a lot for your response Dwain. Your code is successful in keeping the families together and ordering the items by date as long as the parents have different dates....

dwain.c, Completely understood. I will update here of any exceptions and how I handle them. Thank you.

iBar,

Your script is of great help. Anyways, my data doesn't necessarily need to have just '.com' in the domain part. It may end with .net, .co, .edu ...etc. The solution...

Thanks GSquared, I will go with T-SQL as I am not familiar with .NET Assembly. Very helpful.

Sorry Lynn, New to this forum. I don't repost from nect time. Thanks.:-)

Lowell,

As Lynn said, this was the original post and as no one replied till last night, I have created a re-post of it so that it will be in the...

Dwain, ChrisM@Work -

Both of your scripts are working great for my set of documents. Thanks much!