I should of paid better attention to the date.

I am interested.

I realize that this is an old post, but we had the same issue as this person states. To solve our issue, we dropped the role for all who...

I appreciate the link. Bangkok, never been that far east. Like stated before, I would like to wrap my head around this before I ask some questions.

My friend, if you are ever in the Des Moines, Iowa area, I owe you a beer or a glass of wine, whatever your preference may be. Please let...

If Reference_Account_Number_2 is 0 this would be a parent account as there are no other accounts associated with it at this point. A child account would be an account...

I am intrigued. How do you build two recursive legs within one cte? You have my attention.

I am open to suggestions. Could you provide an example please? Nothing fancy just an idea.

Determined from what table the account number was selected from, parent or child. If I am looking at this incorrectly, please let me know as this has me baffled.

Does the attachment I included make sense. I am trying to track how an account number changes over time, but as they do change there is still a root...

Yes. I believe so.

I do not have to have 2 tables. Was just to keep my sanity. Answer to other question was yes.

The code that is listed is actually a compiled stored procedure that is called from the SSIS package. The code is merely for demonstration purposes.

This post is also two...

I would have to agree with Mr. Moden.

Thank you both for your time. I will look through this information and let you know how it goes.