alter proc Sp_GetEmpEqp @jobid int as -- Sp_GetEmpEqp 83 declare @EqpCode int SELECT j.JobID, eq.EquipmentCode, e.EmployeeCode, e.EmployeeName, CASE WHEN dbo.GetEmployeeShift(e.EmployeeID) = 0 THEN 'Day' WHEN dbo.GetEmployeeShift(e.EmployeeID) = 1 THEN 'Night' END AS 'Shift' FROM Job j left join Employee e on e.LocationID = j.JobID left join Equipment eq on eq.JobID = j.JobID where JobCategoryID = 3 and j.[Status] = 0 and j.JobID = @jobid
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)