CREATE PROCEDURE [dbo].[sp_SensorsChangeHistoryDelete]
				@RecordId						INT	= NULL,
				@SensorId						INT = NULL
AS
BEGIN
	SET NOCOUNT ON;
	IF( @RecordId IS NULL)
	BEGIN
		IF (@SensorId IS NULL)
		BEGIN
		     DELETE FROM [dbo].[SensorChangeHistory]
		END
		ELSE
		BEGIN
			 DELETE FROM [dbo].[SensorChangeHistory] WHERE [SensorId]=@SensorId
		END
	END
	ELSE
	BEGIN
		DELETE FROM [dbo].[SensorChangeHistory] WHERE [RecordId]=@RecordId
	END
END