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
| CREATE VIEW V_Calcul_vitesse1 AS
WITH
T01 AS
(
SELECT [Date_Heure], [MACHINE], [Ds(mm)], [RATIO], [S(mm²)], [Vi(m/s)],
ROUND(([Vi(m/s)]/(([Ds(mm)]/1000)*(3.14))*60), 2) AS V, 1 AS C
FROM Calcul_vitesse1
),
T02 AS
(
SELECT [Date_Heure], [MACHINE], [Ds(mm)], [RATIO], [S(mm²)], [Vi(m/s)],
ROUND(([V(m/s)]/(([Ds(mm)]/1000)*(3.14))*60), 2) AS V, 2 AS C
FROM T01
),
T03 AS
(
SELECT [Date_Heure], [MACHINE], [Ds(mm)], [RATIO], [S(mm²)], [Vi(m/s)],
ROUND(([V(m/s)]/(([Ds(mm)]/1000)*(3.14))*60), 2) AS V, 3 AS C
FROM T02
)
SELECT * FROM T01
UNION ALL
SELECT * FROM T02
UNION ALL
SELECT * FROM T03 |
Partager