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--