Problem in stored procedure
I have the following error when I execute this stored procedure. Can someone please help?
Msg 208, Level 16, State 6, Procedure InsertIndicator, Line 28
Invalid object name 'dbo.InsertIndicator'.
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[InsertIndicator]
(
@Module nvarchar(MAX),
@ModuleID int,
@Indicator nvarchar(Max),
@ReturnValue int Output
)
AS
Select Module
FROM Modules
Where Module=@Module
IF @@ROWCOUNT >= 1
Begin
Select Indicator
FROM Indicators
Where Indicator=@Indicator
IF @@ROWCOUNT = 0
Begin
INSERT INTO [dbo].[Indicators] VALUES
(@ModuleID, @Indicator);
SELECT @ReturnValue=0
return
End
ELSE
SELECT @ReturnValue = -1
END
ELSE
SELECT @ReturnValue = -1
|
