CREATE PROCEDURE [dbo].[sprocFilterByFYCode_KPI_PERSONEList]
@filterValue varchar(50)
AS
BEGIN
SELECT
kp.ID,
ks.[DESCRIPTION] AS KPI_CODE,
ann.ID AS FY_CODE,
kp.EMPLOYEE_ID,
kp.[KEY],
kp.PERIOD_START,
kp.PERIOD_END,
kp.DEFAULT_TARGET,
kp.INITIATIVE,
kp.ATTACH_FILE,
kp.LAST_UPDATE,
kp.[STATUS],
kp.APPROVER,
ks.KPI_CODE AS KPI_CODE_ID
FROM
KPI_PERSON as kp
LEFT JOIN
ANNUAL_ASSESSMENT as ann on kp.FY_CODE = CONVERT(int,ann.ID)
LEFT JOIN
KPI_STRUCTURE as ks on kp.KPI_CODE = ks.KPI_CODE
WHERE kp.FY_CODE = @filterValue
ENDYou can pass the specified parameter like showing in the above or on the another way you can also use like the following: WHERE kp.FY_CODE LIKE @filterValue filtering Like keyword.
But, note that you do not require ‘ or double code kp.FY_CODE = ‘@filterValue‘ or kp.FY_CODE LIKE ‘@filterValue’ like this.
Containing single or double code can’t work probably when you run your project in the browser although you can test and show correct results/records well in the SQL Management Studio.
No comments:
Post a Comment