How to fill a table with test data?

[sfn6]

I'm trying to fill a table with about 100 or so UNIQUE records so I can test a search function.

I know I could just loop a stored procedure to fill it, but the data has to be unique. Short of sitting here manually entering is there anything I can do?

Thanks in advance!

 

[tlbroadbent]

What type of data do you want in the test table? Character, numeric, binary? How many columns? Do you have existing table(s) with similar data? Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[sfn6]

whoah...quick reply..thanks

42 columns.

It's a patient registry that contains patient info, so just about every data type is used.

I can export data into a .dba file from the old application, but many of the variables are diffferent. Other than that, I have nothing with similar data.