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 |
|
VeselaApo
Posting Yak Master
114 Posts |
 Posted - 2010-11-15 : 18:07:53
|
| Hi,I have an assignment to build a sql script for modeling purposes. The model is an amortization schedule of a car loan and has several different columns with calculations and 36 rows representing 3 years (3 X 12 months). The challenge is to build the model in such a way that I can easily change the amortization period from 36 months into 18, 12, 24, etc. which will make the rest of the formulas on the other columns re-calculated for the new period. Any suggestions on how can I approach this and build this model? What functions should I use?thanks! |
|
|
jcelko
Esteemed SQL Purist
547 Posts |
Posted - 2010-11-16 : 11:44:45
|
| >> The model is an amortization schedule of a car loan and has several different columns with calculations and 36 rows representing 3 years (3 X 12 months). <<Have a "header" table with the basic loan information which is referenced by a "payments" table. The header has the number of payments and the payments use that value.--CELKO--Books in Celko Series for Morgan-Kaufmann PublishingAnalytics and OLAP in SQLData and Databases: Concepts in Practice Data, Measurements and Standards in SQLSQL for SmartiesSQL Programming Style SQL Puzzles and Answers Thinking in SetsTrees and Hierarchies in SQL |
 |
|
|
|
|
|
SQl Modeling