Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tekmonkey
Starting Member
3 Posts |
 Posted - 2008-04-07 : 10:53:43
|
HiI am creating a database to hold statistics and want to produce web pages with graphs etc based on the data.Is it better to create the formulas on the record and just pull that data accross or create the formulas in sql select statement at run time?Any answers and points of view very welecome Tekmonkey |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-04-07 : 12:09:35
|
| Depends on the situation.You should keep the underlying data separate from any calculated values.Whether you use views, calculated columns, materialised data depends on efficiency and how often the calculations need to take place.If you are uncertain then put it in the select statement and you can change it later. If you always access the database via stored procedures then you can make these changes without affecting the application - views can be used in a similar way but are less flexible.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Data Type Formula