Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Call stored procedure from trigger (multiple records upd
Message
 
 
To
25/02/2007 04:01:07
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01198598
Message ID:
01198648
Views:
6
You'll have to write a wrapper SP that will accept the list of ItemCode/Qty, process it and pass one by one to your SP. You can use a temproray table to pass the list to a wrapper SP.

>
>I have stored procedure that accept ItemCode, Qty as parameter. This procedure will update Item qty based on item code provided. In this stored procedure, it check for certain rules before update qty.
>
>If I update/delete 10 records using SINGLE update/delete statement, how could I call this SP and pass the relevant parameters?
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform