Bob Hovious (8/14/2009)

---

You could create a recursive CTE to chase down all the child rows and insert the result into your target table.

;with cte as (recursive chase pointers)

insert into targetTable

select...

Bob Hovious (8/14/2009)

---

My question is: why you don't just generate the entire set of rows to be inserted along with the KIT and then insert them without launching the trigger...

Wooot....

Thanks a lot !

Hi,

This is a very powerful technique.

I'm just stating to think in terms of result set instead of thinking in terms of sequential programming (cursors) for my triggers.

This technique will prove...

Hi,

Thanks both for the quick reply.

I guess that internally, the server "knows" which rows of TableA are included in the JOIN, though what I'd like to know is how it...

Jonathan,

Sorry, I was busy with some other aspect of our project. Had to put the trigger aside for a while.

I've done some googling, and it would seem that a common...

Jonathan,

The use case is quite simple.

When a row is inserted/updated/deleted to the OrderDetails table, if any of the row refers to an Item that is defined as a Kit, we...

Jonathan,

Yes, thank you for the code snippet.

In view of your comments about CLR Integration, I'll rethink my use of it. In the application that we're developing, we don't use many...

Hi,

Thanks for taking time to reply to my post.

I must say I'm a bit surprised to see someone posting on a CLR Intergration forum and trying to discourage people from...