Conditional Stored Procedure execution
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 64
- Joined: Tue Sep 23, 2008 9:54 am
Conditional Stored Procedure execution
How do I execute stored procedures on conditions in Server Job , ODBC stage? If statements are giving me errors.
You can't. Split the flow and only send the ones needing the SP call down one branch, all others down another. Join the stream back together after that. That or call it each time and conditionally use the result. Of course, that depends on what exactly it is your SP is doing.
Another option - code the SP itself to be conditional. Always call it but pass it an argument so it knows whether it should 'execute' itself or not.
Another option - code the SP itself to be conditional. Always call it but pass it an argument so it knows whether it should 'execute' itself or not.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 64
- Joined: Tue Sep 23, 2008 9:54 am
-
- Participant
- Posts: 117
- Joined: Wed Feb 06, 2013 9:24 am
- Location: Chennai,TN, India