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
|
ALTER PROCEDURE ProcAgregare
@DataOraPlecare datetime,
@DataOraSosire datetime,
@TipAutomobil varchar(255),
@TipCombustibil varchar(255)
AS
BEGIN
SELECT tab3.IdTip,
tab1.DataOraPlecare,
tab1.DataOraSosire,
tab3.TipAutomobil,
tab3.TipCombustibil,
AVG(CombustibilConsumat) AS avgCombustibilConsumat
FROM dbo.FoaieParcursMasina AS tab1
INNER JOIN dbo.PatrimoniuMasini AS tab2
ON tab1.IdMasina = tab2.IdMasina
INNER JOIN dbo.TipuriAutomobile AS tab3
ON tab2.IdMasina = tab3.IdMasina
WHERE (DataOraPlecare >= @DataOraPlecare AND DataOraPlecare <= @DataOraSosire)
AND
(DataOraSosire >= @DataOraPlecare AND DataOraSosire <= @DataOraSosire)
AND
(tab3.IdTip = @TipAutomobil AND tab3.TipCombustibil = @TipCombustibil)
GROUP BY tab3.IdTip,
tab1.DataOraPlecare,
tab1.DataOraSosire,
tab3.TipAutomobil,
tab3.TipCombustibil
END
GO
EXEC ProcAgregare '020207 09:32:35','020207 11:20:32','camion','benzina' |
Partager