CREATE PROCEDURE [dbo].[ASS_INVENTORY_UNSTOCKED_Del] 
		@p_UNSTOCKED_ID	varchar(15)

AS
BEGIN
	BEGIN TRANSACTION
		DECLARE @Error NVARCHAR(MAX) = ''

		IF EXISTS (SELECT * FROM ASS_INVENTORY_UNSTOCKED WHERE UNSTOCKED_ID = @p_UNSTOCKED_ID)
		BEGIN
			DELETE ASS_INVENTORY_UNSTOCKED WHERE UNSTOCKED_ID = @p_UNSTOCKED_ID
		END
		ELSE 
		BEGIN
			SET @Error = N'Không tìm thấy mã'
			GOTO ABORT
		END

		IF @@Error <> 0 GOTO ABORT
	COMMIT TRANSACTION
	SELECT '0' as Result, @p_UNSTOCKED_ID  id, '' ErrorDesc
	RETURN '0'
	ABORT:
	BEGIN
			ROLLBACK TRANSACTION
			SELECT '-1' as Result, '' id, @Error ErrorDesc
			RETURN '-1'
	End

END