I create a table....
create table matrix (x int not null,y int not null,element numeric(18,2) not null PRIMARY KEY (x,y))
I want to populate it with values for a matrix of 15(x) by 15(y). This would mean I'd want all unique combinations OF x AND y up to 15 in each case. I don't seem to be able to do it with SQL Data Generator.
Compound keys consist of several columns, in which all values are known (not null) and, in combination, are unique.