Samuele E. Locatelli
25 lines
591 B
SQL
25 lines
591 B
SQL
/*************************************
|
|
* STORED PROCEDURE sp_setPresaInCarico
|
|
* indica la richiesta come presa in carico con data/ora attuale del server
|
|
*
|
|
* modif.: S.E.L. - 2009.01.22
|
|
**************************************/
|
|
CREATE PROCEDURE dbo.sp_setPresaInCarico
|
|
(
|
|
@numIntMtz INT,
|
|
@idxStatoNew INT OUTPUT
|
|
)
|
|
AS
|
|
|
|
BEGIN tran
|
|
-- inserisco data presa in carico
|
|
UPDATE InterventiMtz
|
|
SET presaInCarico = GETDATE()
|
|
WHERE (numIntMtz = @numIntMtz)
|
|
|
|
-- aggiorno da machcian a stati...
|
|
exec sp_procStatEv @numIntMtz, 1, @idxStatoNew
|
|
COMMIT tran
|
|
|
|
RETURN (@idxStatoNew)
|