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...

Lynn Pettis (8/12/2010)

---

Jack Corbett (8/12/2010)

---

My kids start school today. I can't believe how early school starts in FL. We are starting earlier than most other schools, but still,...

Back on topic, someone decided to post a request for T-SQL problem solution in the commentary of the new article I wrote. Did the whole "Here's my problem. Solve it...

I just have to say:

Us'n Mid-WESTerners ain't got akcents. @=)

Answering the questions backwards:

2) No, I did not create...

Alexander-1013105 (8/12/2010)

---

LFSRs are basically very simple, very fast pseudo-random number generators that generate a set of unique, non-repeating (but cyclic) numbers.

This is possibly not a solution for implementing in T-SQL,...

wppatton (8/12/2010)

---

I have been looking for scripts that already exisit for this, no luck yet. Any help would be greatly appreciated and of course the solution credited to the author....