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 |
|
tfountain
Constraint Violating Yak Guru
491 Posts |
 Posted - 2003-02-07 : 09:20:55
|
| Ok, here is the scenario. We have different rules a user can enable or disable via an interface. Basically, these rules are conditions that have to be meet to send data to an external source (third parties, carriers, etc). I'm looking for ideas on how to implement this in SQL 2000. These conditions evaluate data and can return multiple actions to occur. Typically, we've used functions that are executed dynamically but they've never returned more than a single scalar result. I've played around with inline table-valued functions and multi-statement table-valued functions but they seem clunky and I can not get the table back unless the function is used in the FROM clause of a SELECT statement. However, I do not know in advance how many rules will be enabled and would rather not build a dynamic SELECT statement considering each rule takes in like 60 parameters.Any ideas?Just an additional note. One of the main reasons we took the route of functions is due to the fact that the process that will execute these functions are long running jobs. I wanted to limit the options of hitting the database again.Edited by - tfountain on 02/07/2003 09:40:53 |
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2003-02-07 : 14:39:12
|
| Update: I decided to use a function but instead of returning a table variable, it will return an integer. I'll use bitwise operations to manipulate the different bits that will represent the actions to perform. |
 |
|
|
|
|
|
Ideas for dynamic code execution