Samuele Locatelli
25 lines
529 B
Transact-SQL
25 lines
529 B
Transact-SQL
/***************************************
|
|
* STORED stp_LP_deleteQuery
|
|
*
|
|
* elimina lista di prelievo (e righe lista associate) della list aindicata
|
|
*
|
|
* Steamware, S.E.L. 8 (from Stintino)
|
|
* mod: 2010.07.15
|
|
*
|
|
************************************/
|
|
create PROCEDURE [dbo].[stp_LP_deleteQuery]
|
|
(
|
|
@Original_CodLista varchar(12)
|
|
)
|
|
AS
|
|
|
|
-- cancello righe lista
|
|
DELETE FROM RigheListePrelievo
|
|
WHERE CodLista = @Original_CodLista
|
|
|
|
-- cancello record lista
|
|
DELETE FROM ElencoListePrelievo
|
|
WHERE CodLista = @Original_CodLista
|
|
|
|
RETURN
|