Arrays in a database

Question

Hi all I would like to do the following: put large numeric arrays in a SQL Server database together with some decriptive data. What is the most efficient way to do that? Kind regards Peter

Administrator · Answer

I am working on a population projection. Here is an example: int AGE = 110; //Max age int SEX = 2; // 1=Man 2= Woman int GRP = 12; // Population groups int TIME = 120; // Number of years. 20 years of history + 100 year projection double[] population = new double[AGESEXGRPTIME]; Regards Peter

Administrator · Answer

Do you have to store them as arrays? Maybe post some sample data so we have a better idea of what you have to store.