OK, here is the code, and some data:

/*Create Maximum ID table for getting IDS*/
CREATE TABLE MaxID (
MaxID int
)

/*Create Fact data table*/
CREATE TABLE FactData (
ID int NULL,
Name varchar(50) NULL
)

/*Insert some random maximum ID value*/
INSERT INTO MaxID VALUES (3423)

/*Insert fact values*/
INSERT INTO FactData VALUES (NULL,'Bob')
INSERT INTO FactData VALUES (NULL,'Dan')
INSERT INTO FactData VALUES (NULL,'Jane')

/*Insert more code here to give FactData id values. End result should
be that one row should be 3423, one should be
3424, one should be 3425. Doesn't matter which row is which, as long as
they have IDs*/


Thanks,
Kayda


[quoted text, click to view]