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
| ALTER PROCEDURE [dbo].[USP_DIFFERENTIAL_PRESSURE]
@VARIABLE VARCHAR(MAX)
,@TYPE_PERIODE INT
,@DATE_DEBUT DATE, @DATE_FIN DATE
,@HEURE_DEBUT VARCHAR(8), @HEURE_FIN VARCHAR(8)
AS
BEGIN
DECLARE
@VAR_VARIABLE VARCHAR(MAX) = @VARIABLE
,@VAR_TYPE_PERIODE INT = @TYPE_PERIODE
,@VAR_DATE_DEBUT INT = cast(convert(varchar(8),cast(@DATE_DEBUT as date),112) as int)
,@VAR_DATE_FIN INT = cast(convert(varchar(8),cast(@DATE_FIN as date),112) as int)
,@VAR_HEURE_DEBUT VARCHAR(8) = @HEURE_DEBUT, @VAR_HEURE_FIN VARCHAR(8) = @HEURE_FIN
select
s.Code_Site, s.Libelle_Site
,cl.Code_Client, cl.Libelle_Client
,e.Code, e.Libelle_Equipement
,u.Unite, f.Ide_Date
,cast(cast(f.Ide_Date as varchar(8)) as date) Date_Jour
,f.Heure_Complete
,f.Heure
,f.Heure+':'+f."Minute" Heure_Minute
,f."Minute"
,f.Seconde
,@VAR_TYPE_PERIODE Type_Periode
,v.Variables
,f.Differential_Press
from FAIT_COMPT_GAZ_LIVRE f
join DIM_VARIABLE v on f.Ide_Variable = v.Ide_Variable
join DIM_SITE s on f.Ide_Terminal = s.Ide_Site
join DIM_CLIENT cl on f.Ide_Clients = cl.Ide_Client
join DIM_EQUIPEMENT e on f.Ide_Equipements = e.Ide_Equipement
join DIM_UNITE u on f.Ide_Unite = u.Ide_Unite
where
f.Ide_Date between @VAR_DATE_DEBUT and @VAR_DATE_FIN
and f.Heure_Complete between @VAR_HEURE_DEBUT and @VAR_HEURE_FIN
and CHARINDEX(',' + CAST(f.Ide_Variable AS VARCHAR(MAX)) + ',', ',' + REPLACE(@VAR_VARIABLE, ' ', '') + ',' ) > 0
order by f.Ide_Date, f.Heure, f."Minute", f.Seconde
END |
Partager