Everything you need to know about backup and disaster recovery with AWS, for FREE!
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.