Pass two parameters(DepartmentId, jobtype). Then modify the procedure based on that.
ALTER PROC usp_GetJobCheckListDetails_sel
(
@deptId VARCHAR(500),
@jobType VARCHAR(50)
)
AS
BEGIN
SELECT J.CheckListId, JobNo, DepartmentId, CheckListName, ControlValue, jobtype FROM tbl_JobCheckList J
INNER JOIN tbl_DepartmentCheckList D ON D.CheckListId=J.CheckListId
WHERE DepartmentId IN (@deptId) AND jobtype = @jobType
END
Then call the Sp like below.
EXEC usp_GetJobCheckListDetails_sel ''2','4','5'','5'
This is the write way.