First you see these linka to get Idea to write stored procedure.
1.
Sql Server - How to write a Stored procedure in Sql server[
^]
2.
http://www.mssqltips.com/sqlservertutorial/162/how-to-create-a-sql-server-stored-procedure-with-parameters/[
^]
For Creating Stored procedure
step1:Create Procedure with name like
Create Procedure MyProc
step2: Declare if you have any input parameters /output parameters.
Create Procedure MyProc
(
Input parameters ,
Output Parameters (If required)
)
Step3: write
AS BEGIN statement
step4: write your query
step5:Write END
step6: To Excute Storedprocudure
EXEC 'MyProc'
After SP Looks like:
Create Procedure MyProc
(
@PreviousYear int,
@CompanyID int,
@EMPCode varchar(50)
)
As
Begin
select sal_det_id, comp_id, sal_id, sal_isdeduct, sal_det_desc, sal_det_hrs,sal_det_amt as sal_det_amt,sal_det_cpf from salary_details where sal_det_deleted = 0
and sal_isdeduct = 1 and sal_id IN ( select sal_id from salary_master where sal_deleted = 0 and sal_Year =@PreviousYear and comp_id = @CompanyID and emp_code =@EMPCode )
End
to execute above sp
exec MyProc 2013,1,'EMP1'