quote:

---

Originally posted by gogetthealok_55

i m getting this error when i m trying to execute a stored
procedure.


Msg 137, Level 15, State 2, Procedure Schema_ID, Line 26
Must declare the scalar variable "@Priority_ID".


CREATE PROCEDURE Schema_ID
-- Add the parameters for the stored procedure here
@Scheme_ID nchar(10),
@Scheme_Name nvarchar(50)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
DECLARE @Scheme_IDID intnchar(10),@Priority_ID int
Insert Scheme(Scheme_ID,Scheme_Name)
Values
(@Scheme_ID, @Scheme_Name)

-- Insert statements for procedure here
SELECT @Scheme_IDID = @@Identity

Insert into Pri_Sche
(Priority_ID, Scheme_ID)
Values
(@Priority_ID, @Scheme_ID)
END
GO

---