0

Hi

am using sql server 2005..
I hav a query like this.

create PROCEDURE [dbo].[csp_UpdateAutoPart]
(
	 @Code NVARCHAR(6)
	,@Quantity INT
	,@UnitPrice DECIMAL
)
AS
BEGIN
	

	-- Update the autopart details
	UPDATE	 dbo.AutoPart 
	SET		 dbo.AutoPart.Quantity   =   @Quantity 
		    ,dbo.AutoPart.UnitPrice =   @UnitPrice
	WHERE	 dbo.AutoPart.Code       =   @Code

end

While executing it, almost 32 rows are getting updated and an error "Msg 217, Level 16, State 1, Procedure csp_UpdateAutoParts, Line 45
Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32).
" also is displayed

2
Contributors
3
Replies
5
Views
8 Years
Discussion Span
Last Post by Ramy Mahrous
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.