Here are the relations:

Table ptChemoOrders:

-------------------------------

OrderID -- PK

DateOfService

MRN

Table ptChemoMedicareBilling:

-------------------------------

ID --...

Thanks, Jack, but the DOS comes from the ptChemoOrders table not from the

ptChemoMedicalBilling table that the trigger is on. The ptChemoMedicalBilling record is based on the OrderID in ptChemoOrders....

Nevermind, I figured it out myself and have 6 sets of working insert and update triggers.

How would I use ColumnsUpdated() to access the columns that were updated in

the ptChemoOrderDetails table? I intend to write a separate UPDATE trigger.

These are the 9 columns that could affect...

Yes,using your technique, and Yes, 10-fold!

I had to test for a certain value to do each of the inserts and now have it working with

no errors.

However, I am at a loss as to how...

I just tweaked your last post to work for our data.

I also wrote triggers for all the tables involved to do the inserts.

The procedure created from your post is...

Ok, got it working just like we need. Thanks to everyone that helped.

Since I didn't know, I was very careful about how I said what I did in my last post. 😉

I *know* what was meant concerning that part of the reply.

What I was referring to was to show me how to do it without the cursor,

Can you show me what you mean, Lynn?

It's because we have MRN/DOS combinations that we have to do this for.

It is to populate an...

GSquared,

Looks good except I need to filter by the o.MRN and o.DateOfService.

Also many records come over with Comments and several others have NULL Comments.

The particular DOS that I am querying...

Nah, still doesn't work because it seems to be running the select ON master.

Kind of wondering how you would catch any errors when moving the file.

I make a copy to a tempfilename passed into the procedure and then if there is an error...