Files
WebGIM/GimDB/dbo/Stored Procedures/stp_MovMag_getByNumInt.sql
2017-01-27 22:26:50 +01:00

21 lines
386 B
Transact-SQL

/*************************************
* STORED PROCEDURE stp_MovMag_getByNumInt
*
* update record movimenti magazzino
*
* mod : 27/11/2015
* aut : S.E. Locatelli
**************************************/
CREATE PROCEDURE [dbo].[stp_MovMag_getByNumInt]
(
@numIntMtz INT
)
AS
-- cerco da intervento
SELECT *
FROM v_MovMagExpl vmm
WHERE numIntMtz = @numIntMtz
RETURN