Sounds a bit like a Sudoku puzzle, there might be similar techniques you could use

http://www.vsj.co.uk/articles/display.asp?id=540

James Goodwin (8/12/2010)

---

As AndyC mentions this is not a random set.

However, for this case you don't need a random set, you need an arbitrary set of numbers. (More accurately,...

I've tried to implement a LFSR as follows but it's not quite working. But in principle it should be possible.

set nocount on

declare @lfsrTable table(period int,value int NOT NULL)

declare @lfsr int

declare...

There is a terminolgy issue here. The numbers in this sequence are not actually random as we could predict the next number in the sequence by looking at the previous...