1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63
| SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
Alter PROCEDURE essaie
AS
BEGIN
delete from table_4
declare @V1 as int
select @V1 = (A.valeur - B.valeur) from Table_1 A join table_2 B on A.Id1 = B.Id1 where A.origine = 'xx'
insert into table_4
(
id3,
id2,
Valeur,
origine
)
select
A.id1
,B.id2
,@V1
,'sam'
from table_1 A join table_2 B on A.id1 = B.id1
--===============
declare @V2 as int
select @V2 = AVG(Valeur) from Table_4 where origine = 'sam'
insert into table_4
(
id3,
id2,
Valeur,
origine
)
values (
7
,8
,@V2
,'S_Sam')
END
GO |
Partager