Samuele E. Locatelli
41 lines
923 B
Transact-SQL
41 lines
923 B
Transact-SQL
/*************************************
|
|
* STORED PROCEDURE spt_AD_delete
|
|
* elimina la macchina (da famiglia macchina e anagMacchina) SE non ah record associati
|
|
*
|
|
* modif.: S.E.L. - 2013.12.06
|
|
**************************************/
|
|
CREATE PROCEDURE spt_AD_delete
|
|
(
|
|
@Original_idxMacchina int
|
|
)
|
|
AS
|
|
|
|
BEGIN tran
|
|
|
|
|
|
DECLARE @trovati INT = 0
|
|
-- controllo se ha eventi associati ...
|
|
SELECT @trovati = @trovati + ISNULL(COUNT(*),0) FROM InterventiMtz WHERE idxMacchina = @Original_idxMacchina
|
|
-- controllo se ha eventi schedulati ...
|
|
SELECT @trovati = @trovati + ISNULL(COUNT(*),0) FROM MtzProgPending WHERE idxMacchina = @Original_idxMacchina
|
|
|
|
-- elimino solo se ZERO elementia ssociati..
|
|
|
|
IF (@trovati = 0)
|
|
BEGIN
|
|
|
|
DELETE
|
|
FROM Macchine2FamMacchine
|
|
WHERE idxMacchina = @Original_idxMacchina
|
|
|
|
DELETE
|
|
FROM AnagMacchine
|
|
WHERE idxMacchina = @Original_idxMacchina
|
|
|
|
END
|
|
|
|
|
|
COMMIT tran
|
|
|
|
RETURN
|