Hi Friends:
I am new to SQL and trying write stored proc. I am having some difficulties to get default values as an output result.
I have 2 table:
1)Student_Input:
InputID SectionID ParameterName Sequence
1 100 FirstName 1
2 100 MiddleName 2
3 100 LastName 3
2)Student_Input_details:
ParameterName ParameterValue DefaultValue
FirstName John 1
FirstName Troy 0
FirstName Mark 0
I am trying to call ParameterName from Student_Input and Its default value from Student_Input_Details as an output in one table. I am trying with following query but I am getting following error:
Msg 201, Level 16, State 4, Procedure Getparameterdefaultvalues, Line 0
Procedure or function 'Getparameterdefaultvalues' expects parameter '@ParameterValue', which was not supplied.
I am sure I am missing something important here.
Create Procedure Getparameterdefaultvalues
(
@ParameterName varchar(50) ,
@ParameterValue varchar(50) out
)
As
Begin
Select @ParameterValue = DefaultValue from Student_Input_details where ParameterName=@ParameterName
End
Execute Getparameterdefaultvalues 1
I need result like (i.e. ParameterName should only display its default value at runtime):
ParameterName ParameterValue
FirstName John
Apologies If my question is not so cleared. Any help would be grate!! Thx :)