That sounds about right. I'm thinking...

Jeffrey,

Thanks for the response.

After reading your comment, its true updating just inserted fresh data based on logic of the table its being inserted in would be a waste of system...

Dude...out of context... but is that Zidane doing the head-butt on your avatar? :hehe:

I'm not exactly sure of what your requirements are, but it seems UNION would help you out in constructing your query.

Even though I still use my left and inner joins...

I think EXCEPT & Intersect are very nice. It's so much easier to explain data to some one who is not...

I'd like to thank Grant and everybody else that contributed to this topic.

However, I chose a different route from the various above mentioned solutions, OUTPUT clause being the definite...

Grant,

I think i'm missing something here. OKAY I do have key values... and thats what I use to join..

but.....

the child table does not have the key values.. because it does...

Okay, I actually got excited a little earlier than I should have gotten.

OUTPUT clause it seems will benefit only in a situation where there is a ONE-to-ONE relationship between the...

Grant,

Just thought I'd update you and everyone else here that I was successful with the OUTPUT clause. It actually is easy to implement.

I have all the fintproductid's in my...

Grant,

Thanks! I believe you're right. I guess I'm scared of using the OUTPUT clause because I have so much currently going on in my sproc, that i'd hate to delete...

Raj,

That definitely came to my mind as well. The use of triggers to do multiple inserts. However, as far as query performance and efficiency is concerned, would this be effected...

ifila,

I just recently used the MS KB you pointed out at the beginning of the your post. I would say it was a very straight forward process by just putting...

Mahesh,

The problem is that I have no connection between the tblproduct and tblproductsizewidthcolor tables. Now in order for me to do the insert, I have to verify again, because if...

Grant,

Thank you for the advice. I actually did take a look at the OUTPUT clause on BOL. I too think it is what I need but wasn't sure. I...

....:w00t::-):w00t::-):w00t::-):w00t: