I have a table with following structure: Id first quarter second quarter third quarter last quarter year month week day On an entry not all fields of the four quarter fields are covered with values. Following combinations are possible: first quarter | second quarter | third quarter | last quarter
x null null null null x null null null null x null null null null x x x null null x null x null x null null x null x x null null x null x null null x x x x x null x x null x x null x x null x x x x x x x The table will receive many thousands of entry’s. Would it be better to divide the table in to 15 small tables in order to not register fields with null values? Thanks for helping Regards Martin --------------------------------- Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard
