thegiraffe
Programmer
Newbie to programming within t-sql but i'm slowly understanding it.
My problem
We are using an external piece of software but (with permission) are deveoping the back end to work more with our needs.
When a new contact record is entered into a table I want it to check for a few things and on result setup records as to next processes for setting up new contact information.
Their software requires us to use their API shells as a unique record ID is setup in the table I need to insert into.
I don't want to make the trigger to complicated so i would like the trigger to check on a field (such as source), and dependant on this i want to run different setup procedures.
so if source = Client, I want to insert into another pending table that the source needs to be acredited for the referal.
For this I need to have a large shell of exec values to insert into the table (thus wanting to keep it in a seperate procedure), so i would like to have a exec shell setup in a stored procedure, from the trigger call this and pass relevent information inserted info to this stored procedure.
So in short, get inserted info from trigger and pass through to stored procedure.
I need to use stored procedures for this as i would want to use the same process from many different triggers.
Any help will be greatly received
Thankyou Dave
Theres nothing worse than an idea when its the only one we have!
My problem
We are using an external piece of software but (with permission) are deveoping the back end to work more with our needs.
When a new contact record is entered into a table I want it to check for a few things and on result setup records as to next processes for setting up new contact information.
Their software requires us to use their API shells as a unique record ID is setup in the table I need to insert into.
I don't want to make the trigger to complicated so i would like the trigger to check on a field (such as source), and dependant on this i want to run different setup procedures.
so if source = Client, I want to insert into another pending table that the source needs to be acredited for the referal.
For this I need to have a large shell of exec values to insert into the table (thus wanting to keep it in a seperate procedure), so i would like to have a exec shell setup in a stored procedure, from the trigger call this and pass relevent information inserted info to this stored procedure.
So in short, get inserted info from trigger and pass through to stored procedure.
I need to use stored procedures for this as i would want to use the same process from many different triggers.
Any help will be greatly received
Thankyou Dave
Theres nothing worse than an idea when its the only one we have!