ALTER PROCEDURE SP_Name
( @empCode VARCHAR(10), @date DATETIME ) 
with encryption 
AS 
BEGIN 
open symmetrickey code part

SELECT dbo.Decrypt(EmpCode), dbo.Decrypt(EmpName), 
CASE LeaveType WHEN 'ON DUTY' THEN 'OD' 
WHEN 'Paternity' THEN 'CL' 
WHEN 'Absconding' THEN 'A' 
WHEN 'Breav' THEN 'CL' 
ELSE LeaveType 
END, CONVERT(VARCHAR, @date, 101), LeaveStatus FROM Leave_Details 
WHERE CONVERT(DATETIME, CONVERT(VARCHAR, @date, 101)) BETWEEN FromDate AND ToDate 
AND LeaveRequestStatus = 'Authorize' 
AND dbo.Decrypt(EmpCode) = @empCode 

END