Click here to Skip to main content
15,898,035 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi
I have a stored proc which has 2 parameter initially and it works fine, then later I altered the stored proc by adding one more parameter and executed.
But now I got this error, but when I restart the system it will be ok.

Where is the problem?
Posted
v2
Comments
Can you post some relevant codes to look at the issue?
John Sathish Tamilarasu 18-Jan-13 2:08am    
create PROCEDURE [dbo].[EmpMaster_GetCategory]
-- Add the parameters for the stored procedure here
@COMPCODE varchar(10),@UserName varchar(50)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
--SET NOCOUNT ON;

-- Insert statements for procedure here

SELECT ccode,Cname,EsiFormula,GROSSFORMULA FROM CATMASTER WHERE Compcode=@COMPCODE and
ccode in (SELECT ccode FROM TBLUSERCAT WHERE compcode=@COMPCODE and username=@UserName) order by cporder

END

This is my sp
milenalukic 20-Jan-13 18:14pm    
And your third parameter?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900