I like the proc. I made a modified version that works in SQL 2005 (since that's what I'm using right now). If anyone else wants to check that...

There are a couple of ways to check if anything has changed. You could run a checksum on each row, and compare the checksum from the staging table with...

Not sure how Grady did it. I would just...

I prefer to let them evolve organically. But I also like really rambling conversations that wander all over the place. I just think that's fun.

Large XML strings can take a while to parse. What I've sometimes found faster is to insert them into a table (temp or real) that can have an XML...

Because SQL Server devs assumed that we'd know what we're doing and would feed the commands only meaningful procs. In my case, boy were they mistaken!

There are lots of...

What permissions are you trying to grant?

Pretty standard. Gotta agree with you.

It's a common enough practice. I try to avoid it by having that kind of logic in the insert proc, instead of in a trigger, but that's mainly for...

That's pretty much the most efficient way to do that.

Cross apply will do the same thing as inner join will, in this case, because you aren't passing any values from...

Since the forums don't display XML well, please attach a copy of your query and such, stored as a txt file.

I may be missing something, but your proc doesn't appear to actually use the @id parameter anywhere. It should probably be in the Where clause of the proc, and...

Jack Corbett (3/20/2009)

---

I do have a question about the update trigger, you are only inserting the new data into EmpUpd_log so you can't see what the change was. Is...

David Kranes (3/20/2009)

---

Hello, in a recent design meeting it surfaced that these triggers would need to compare the new values in the triggering table with values in another table before...

It should just have the clustered index.

If you want more...