Hi Gail,

Well, for those of us who are really NEWBIES, how can I do that? if you don't mind my ignorance 🙂

Thanks Jack!

I had the same concern, just looking for reassurance I guess. I will move the check into the Transaction so I get all my bases covered.

Kind...

Mister.magoo,

My hat goes off to you, this is very efficient and as Ian put it, ELEGANT! Very nice.

Thanks!

Thanks bitbucket and diamondgm.

I did notice that yesterday as well, but since I need multi-language capabilities, I had to resort to building a table with each language that we use...

Well, it seems that I will have to write it myself. Here's the code for you to use and modify it to make more efficient, just let me know.

Regards...

I appreciate that Gail!

I have used your knowledge and expertise directly and indirectly thru various tasks I have come across and if you are still interested, we could work out...

Hi Gail!

Sure, we are located in Orlando Florida.

Hi Wayne!

I was reading about it in BOL but I got confused cause it says that one needs to create the receiving table with the corresponding structure. I do...

Thanks again to both of you.

Since I have more than 1M rows in the production parent table, it would be very painful. Gail, I applied your exercise of (though...

Gail,

Now it works perfectly! I will attempt to modify it to test it with production data and let you know. Your query gives me a nice starting point...

Thanks Gail!

Sorry I took this long to respond. I tried to execute your code but you missed the join condition and, you will excuse my ignorance, what columns are...

After my previous post, I kept digging and I found the solution. Here's what I was able to create and obtained just one child for each parent.

select child.*

from tbl_children...

Thanks to both for your interest. What I need is a query that will return only one row for each parentID. In the script I provided you will...

Thank Gail!

What I mean by "first" is any child row having the same parentID, I do not care what order or distinctive indicator, mainly because there is none. ...