Hi Ninja,

The SP is already used for other Processes, so that it's not possible to make any modifications in the SP such as passing XML parameters etc.

Just we need to find a way to pass required input parameters through a select statement as specified above.

consider the SP contains the statement to update quantity in items table with reference to Item Code

create procedure UpdateQty

@ItemCode VARCHAR(10)

@Qty INT

AS

UPDATE ITEMS SET Quantity = @Qty WHERE ItemCode = @ItemCode

END

and i have to call this execute this sp as

EXEC UpdateQty

SELECT ItemCode, QtyBO FROM ITEMSPO INNER JOIN ..... <some conditions>

Thanks