Samuele E. Locatelli
24 lines
509 B
SQL
24 lines
509 B
SQL
/*************************************
|
|
* STORED PROCEDURE stp_MovMag_update
|
|
*
|
|
* elimina record movimenti magazzino (SE non scaricato)
|
|
*
|
|
* mod : 27/11/2015
|
|
* aut : S.E. Locatelli
|
|
**************************************/
|
|
CREATE PROCEDURE stp_MovMag_delete
|
|
(
|
|
@Original_idxItem INT = 0
|
|
, @Original_numIntMtz INT
|
|
, @Original_dtMov DATETIME
|
|
)
|
|
AS
|
|
|
|
DELETE
|
|
FROM MovMagRic
|
|
WHERE idxItem = @Original_idxItem
|
|
AND numIntMtz = @Original_numIntMtz
|
|
AND dtMov = @Original_dtMov
|
|
|
|
|
|
RETURN |