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
| @param1 int, @param2 int,
@param3 int, @param4 int,
@param5 int OUTPUT
AS
INSERT INTO TableB
SELECT paquet ,
SUM(Case When Prop1 = 1 And Prop2 = 0 then 1 else 0 end) as Total1,
SUM(Case When Prop1 = 1 And Prop2 = 1 then 1 else 0 end) as Total2,
SUM(Case When Prop2 = 0 then 1 else 0 end) as Total3,
SUM(Case When Prop2 = 1 then 1 else 0 end) as Total4,
[date], Prop5, Prop6, Prop7, Prop8
FROM Table1
WHERE date = cast(floor(cast(getdate() as float)) as datetime)
AND Prop5 = @param1 AND Prop6 = @param2
AND Prop7 = @param3 AND Prop8 = @param4
GROUP BY paquet, date, Prop7, Prop5, Prop6, Prop8;
SET @param5 = (SELECT COUNT(*)
FROM Table2
WHERE date = cast(floor(cast(getdate() as float)) as datetime)
AND Prop5 = @param1 AND Prop6 =@param2
AND Prop7 = @param3 AND Prop8 = @param4);
GO |
Partager