All the concern about protecting data, yes as a DBA you may have a significant role to insure that sensitive data is protected. But how many of you have...

Good question

First of all your table definitions contained a few errors and I corrected same as shown below. I then inserted one row of data into each table.

CREATE TABLE #DONORS(...

Roy Ernest (10/18/2011)

---

Jeff Moden (10/18/2011)

---

bitbucket-25253 (10/17/2011)

---

Jeff for a guy who is 2 days older than dirt, from a guy who is 3 days older than dirt

Thanks for all you have...

Test your code, with this variation. Instead of using a TABLE VARIABLE (@Table) use a Temp Table (#Table)

Look at the QOD posted on 10/03/2011 at

http://www.sqlservercentral.com/Forums/Post.aspx?SessionID=mqk3w345ndswzpnnc0a4njj4

Jeff for a guy who is 2 days older than dirt, from a guy who is 3 days older than dirt

Thanks for all you have done to teach myself and...

Jeff for a guy who is 2 days older than dirt, from a guy who is 3 days older than dirt

Thanks for all you have done to teach myself and...

Have you examined this site?

http://www.carlprothman.net/Default.aspx?tabid=81

or this one

http://www.connectionstrings.com/

REad this and try the code to learn

http://blog.sqlauthority.com/2009/12/15/sql-server-difference-temptable-and-table-variable-temptable-in-memory-a-myth/

or this one .. does not require as much code

http://cybersql.blogspot.com/2009/12/yes-table-variables-and-temp-tables.html

Look up DML triggers .. in Books On LIne. Pay particular attention to the INSERTED and DELETED tables that triggers can generate

Lynn Pettis (10/12/2011)

---

Gianluca Sartori (10/12/2011)

---

Lynn Pettis (10/12/2011)

---

To proudly go where few have gone! Just how many people have gone into space? What an honor it would be to...

Probably should purchase a lot of Redgate software to insure a retun trip

Nice question. Took much too long to shake the cobwebs out of my brain.

WayneS

I'm very fortunate to know Jeff, and I'm honored to consider him a friend. He has taught, and continues to teach all of us many things. And not just high-performance...

Nice question