PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
ALTER PROCEDURE [dbo].[spLoadEquipmentCalibrationGrid] @type_ID INT=NULL, @useAccredited INT=NULL AS BEGIN SET NOCOUNT ON; DECLARE @Accredited VARCHAR(50)=NULL IF @useAccredited <> 0 BEGIN SET @Accredited = ' AND A.accredited <> 0' END IF @type_ID = 0 BEGIN SELECT CONVERT(bit,0) AS 'Selected', A.equipment_ID AS 'Equipment ID', B.equipmentType AS 'Type', C.equipmentName AS 'Name', CONVERT(bit,A.accredited) AS 'Accredited', F.department AS 'Department', REPLACE(G.calibrationHouse,'~','''') AS 'Calibration House', CONVERT(bit,A.active) AS 'Active', D.userAccount AS 'Created By', D.dateCreated AS 'Date Created', E.userAccount AS 'Updated By', e.dateUpdated AS 'Date Updated' FROM HEADER_Equipment A LEFT JOIN LKUP_EquipmentTypes B ON A.equipmentType_ID = B.equipmentType_ID LEFT JOIN LKUP_EquipmentNames C ON A.equipmentName_ID = C.equipmentName_ID LEFT JOIN LKUP_UserAccounts D ON A.createdBy_ID = D.userAccount_ID LEFT JOIN LKUP_UserAccounts E ON A.updatedBy_ID = E.userAccount_ID LEFT JOIN LKUP_Departments F ON A.department_ID = F.department_ID LEFT JOIN LKUP_CalibrationHouses G ON A.calibrationHouse_ID = G.calibrationHouse_ID WHERE A.equipmentType_ID >= 0 + @Accredited END
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.