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 |
|
00kevin
Yak Posting Veteran
78 Posts |
 Posted - 2009-12-05 : 21:02:55
|
| Hi,I have a client that wants me to create a database for him to perform 1000's of different calculations on data stored in a few tables.The problem is that he has requested that those equations be stored in a table as a string. So that he can modify them and hide them from me (or anyone else) This database will have layers upon layers of calculations. Originally I thought I would just have to create a bunch of views for each calculation layer, but now that he told me he has to keep his equations a secret it has become more complex. His equations must remain a secret at all costs.I was thinking of writing functions that read from the equation table, replaced any place holders with field names, and then executed the results with dynamic sql.Does anyone else have any other ideas? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-12-05 : 23:21:00
|
| use stored procs and encrypt them.technically, there's no way for him to completely hide 'em from you, but that ought to satisfy his requirement.or...create tables to store his equations, have him create a few test ones to be sure it works, then remove your db access altogether. |
 |
|
|
|
|
|
dynamic sql for top secret equations ?