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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-02-10 : 09:49:48
|
| John writes "I'm trying to create a routing tool within sql server. The front end will be programmed with asp.net/vb. I can't find any documentation on how to go about doing this and to be honest I haven't a clue. I want to have the ability to program complex and simple workflows that will route specific records to key individuals. It doesn't stop here though. Say there are five people on a workflow, really never this small, each person will have to approve if a certain condition is met, then the record will be passed to the next person in sequence. Say for example we have John, Joe, Marie, May, and Don on a team. John, Joe, and Don will receive all records that total less than $300. Marie and May will only look at records above this amount. When John receives the record he will have to approve it or deny it. If he denies it, then it cancels the planned route and instead goes back in the table with a flag of some sort. If he approves it, then Joe will recieve the record. The same rule applies for all the others.I don't know if you will be able to answer this question because there are so many variables and the complexity might be a bit much. Then again, this question might be really simple for your team to figure out. I'm stumped with this. If you can help it would surely be appreciated." |
|
|
|
|
|
Creating a workflow/routing tool with sql server