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

Answer 1

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[AGE,SEX,GRP,TIME]; Regards Peter

Answer 2

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.