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

this is the code after masking.