ALTER PROCEDURE [dbo].[sp_SensorsDeleteAll]
		@errorNumber				INT OUTPUT,
		@errorMessage				NVARCHAR(255) OUTPUT
AS
BEGIN
	SET NOCOUNT ON;
	SET @errorNumber=0
	SET @errorMessage=''

	begin try
		begin transaction [tDeleteSensors]
		DELETE FROM [dbo].[SensorChangeHistory]
		DELETE FROM [dbo].[SensorCalibrationRecordPolynomial]
		DELETE FROM [dbo].[SensorCalibrationRecordIRTracc]
		DELETE FROM [dbo].[SensorCalibrationRecord]
		DELETE FROM [dbo].[SensorCalibrations]

		UPDATE [dbo].Channels SET SensorId = NULL

		DELETE FROM [dbo].[SensorsAnalog]
		DELETE FROM [dbo].[SensorsDigitalIn]
		DELETE A FROM [dbo].[SensorsSquib] AS A INNER JOIN [dbo].Sensors AS B ON A.SensorId=B.id WHERE B.SerialNumber != 'TSQ_TestSpecific'
		DELETE A FROM [dbo].[SensorsDigitalOut] AS A INNER JOIN [dbo].Sensors AS B ON A.SensorId=B.id WHERE B.SerialNumber != 'TSD_TestSpecific'

		DELETE FROM [dbo].[Sensors] WHERE [SerialNumber] != 'TSD_TestSpecific' AND [SerialNumber] != 'TSQ_TestSpecific'

		commit transaction [tDeleteSensors]
	end try
	begin catch
		rollback transaction [tDeleteSensors]
		set @errorMessage	= error_message()
		set @errorNumber	= error_number()
	end catch	
END