ALTER PROCEDURE [dbo].[spLoadEquipmentCalibrationGrid] @equipmentType_ID INT=NULL, @calibration_ID INT=NULL AS BEGIN SET NOCOUNT ON; DECLARE @strCalibration_IDs VARCHAR(50) IF @calibration_ID = 4 SET @strCalibration_IDs = '(2,3,4)' ELSE SET @strCalibration_IDs = '(' + @calibration_ID + ')' IF @equipmentType_ID = 0 SELECT equipment_ID AS 'Equipment ID' FROM HEADER_Equipment WHERE A.equipmentType_ID > 0 AND calibration_ID IN @calibration_ID ORDER BY B.equipmentType
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.