Very nice!  Thank you.  As I said, my "limited" understanding of recursive design and configuration.  This will be very useful to read and learn. 

Very impressive!  This will take me a bit to figure out...   

The LEFT OUTER JOIN is throwing me....

What do you get?  I ran this and it looked like what you wanted...  (Note: message 3 should display before message 2 - I did that on purpose to make...

Try adding the following to my original query: 

INSERT INTO #Messages( PK, ConnectorKey, Message, MessageDate)

VALUES( 5, 4, 'Third Message 2nd Addendum', '8/22/2005 4:54:52 PM')

I think you will find...

I think you may have not understood my ConnectorKey field.  That is what makes this recursive.  Plus, I put message 3 in before message two to show that mine should...

Are you trying to join two tables which do not actually have foreign keys by joining them based upon the timestamp being within, (not sure about this) one hour? 

In...

Can't you make a new Identity Column.  SET IDENTITY_INSERT tablename OFF.  Then insert the existing data and SET IDENTITY_INSERT tablename ON?    (This is...

I am sorry - I have not been following this as I should have. 

Salvatore, could you post what sushila asked.  That would probably give us the best approach at...

LOL.  Excellent response.   

Here's another possible approach.  It is very similar to Adrienne's. 

CREATE TABLE #Messages( PK integer,

                                            ConnectorKey integer,

                                            Message varchar(50),

                                            MessageDate datetime)

INSERT INTO #Messages( PK, ConnectorKey, Message,...

Sorry its not more exciting... 

That's a worthwhile trade off.  Thanks. 

Funny.    You handed me one of your most common one's just hours ago... 

Thanks.  I knew I should have taken the time to include the other processes. 

There are a lot of business rules and I cannot really go into them all; in...

I worked for a financial agency, (you would know the name) and we were getting lots of data in from many sources.  Every time, I would be told this was...