Does it have to be a trigger?

Could you not change your code that populates the "other" tables into populating this table at the same time? Stored procedures and transactions...

Jack Corbett (8/17/2010)

---

Roy Ernest (8/17/2010)

---

I am disappointed. I was trying to get Redgate to sponsor a speaker for our user group. They came up with an idea that Brad could...

You know, I've never thought about trying a remote presentation. Now there's an idea to get more speakers "out" to more events.

Incorrigible.

It's not a theoretical exercise. I actually had to do this for a project. And setting up encryption was not an option given me.

EDIT: Since I had to jump through...

CirquedeSQLeil (8/13/2010)

---

Nothing like coming in to work to find out that the server team deployed patches to production boxes, caused an outage, didn't communicate that fact, and did not follow...

Jeff Moden (8/13/2010)

---

AndyC London (8/12/2010)

---

Other functions to play with with regards to generating test data are the HashBytes function and CHECKSUM function which both have the useful property of being...

Jeff Moden (8/13/2010)

---

You can see that an average of about 520 numbers out of the million duplicate on each run. The run above (not including the dupe check) takes...

Jeff Moden (8/13/2010)

---

wppatton (8/12/2010)

---

Jim,

It's not even close to being a homework problem. I wouldn't post homework for someone else to do. It's real world problem being brought to me...

shad-873858 (8/12/2010)

---

You will get much higher degree of uniqueness if you look at the least significant digits of your RAND() instead of the most significant.

In your Tally solution, simply changing...

Gail & Paul, that's for the clarification.

Kwit larnin' things! That ain't what this here site be for!

😀

Paul White NZ (8/12/2010)

---

What sort of hint did you have in mind? Index...

Holland is a province in the Netherlands. It isn't the whole country.

wppatton (8/12/2010)

---

Jim,

It's not even close to being a homework problem. I wouldn't post homework for someone else to do. It's real world problem being brought to me by a...