Samuele E. Locatelli
25 lines
546 B
Transact-SQL
25 lines
546 B
Transact-SQL
/*************************************
|
|
* STORED PROCEDURE stp_MovMag_update
|
|
*
|
|
* update record movimenti magazzino
|
|
*
|
|
* mod : 27/11/2015
|
|
* aut : S.E. Locatelli
|
|
**************************************/
|
|
CREATE PROCEDURE [dbo].[stp_MovMag_update]
|
|
(
|
|
@Original_idxItem INT = 0
|
|
, @Original_numIntMtz INT
|
|
, @Original_dtMov DATETIME
|
|
, @Qta INT
|
|
)
|
|
AS
|
|
|
|
UPDATE MovMagRic
|
|
SET Qta = ISNULL(@Qta,0)
|
|
WHERE idxItem = @Original_idxItem
|
|
AND numIntMtz = @Original_numIntMtz
|
|
AND dtMov = @Original_dtMov
|
|
|
|
|
|
RETURN |