[Solved] SQL Server Stored Procedure Error: incorrect syntax near else

Hi makumbi,

End is missing for Begin.

Use this.

CREATE PROCEDURE [dbo].[P3P7marksheetLast]
	@C nvarchar(50) AS
begin
	if @C='P3'
	BEGIN
		exec deletedestemp
		exec Classgeneral @C
 
		exec Delnulpositions
		exec deletedestemp
		Update destinationtemp set pos= case when division ='x' then 100000 else pos end
		exec Delnulpositions2
	END
	else
	begin
		exec destinationdelete
		exec Generalupperp @c
		exec Runclassposition
		Update destination37 set pos= case when division ='x' then 100000 else pos end
	end
END