Best Practice?

[ormsk]

Hi

i am developing an application for a snooker league with league tables etc.

My question is:

1. Should I generate leaue tables from SQL each time they are required OR
2. Have a table that keeps track of results as they are entered and modify table if results are required to be changed / deleted?



There is more than one way to skin a cat...but who wants a skinned cat?

 

[jrbarnett]

I would say that item no. 2 is preferable, but you should only need to modify the table for structure changes. All you would need to do is to modify / add / delete records within that table or tables.

John