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 64 65 66 67 68 69 70
|
CREATE FUNCTION MIM_ExtraitDateFinFR(@Chaine AS VARCHAR(20), @vNumeroPromo AS INT) RETURNS varchar(100) AS
BEGIN
DECLARE @DFin VARCHAR(50)
DECLARE @DFinJ VARCHAR(3)
DECLARE @DFinM VARCHAR(3)
DECLARE @DFinA VARCHAR(3)
IF (@vNumeroPromo=1)
select @DFin = SUBSTRING(CAST(CONVERT(DECIMAL (13,7),PrixSolde1) AS VARCHAR),8,6)
from solde
where reference = rtrim(@Chaine)+'P'
IF (@vNumeroPromo=2)
select @DFin = SUBSTRING(CAST(CONVERT(DECIMAL (13,7),PrixSolde2) AS VARCHAR),8,6)
from solde
where reference = rtrim(@Chaine)+'P'
IF (@vNumeroPromo=3)
select @DFin = SUBSTRING(CAST(CONVERT(DECIMAL (13,7),PrixSolde3) AS VARCHAR),8,6)
from solde
where reference = rtrim(@Chaine)+'P'
IF (@vNumeroPromo=4)
select @DFin = SUBSTRING(CAST(CONVERT(DECIMAL (13,7),PrixSolde4) AS VARCHAR),8,6)
from solde
where reference = rtrim(@Chaine)+'P'
IF (@vNumeroPromo=5)
select @DFin = SUBSTRING(CAST(CONVERT(DECIMAL (13,7),PrixSolde5) AS VARCHAR),8,6)
from solde
where reference = rtrim(@Chaine)+'P'
IF (@vNumeroPromo=6)
select @DFin = SUBSTRING(CAST(CONVERT(DECIMAL (13,7),PrixSolde6) AS VARCHAR),8,6)
from solde
where reference = rtrim(@Chaine)+'P'
IF (@vNumeroPromo=7)
select @DFin = SUBSTRING(CAST(CONVERT(DECIMAL (13,7),PrixSolde7) AS VARCHAR),8,6)
from solde
where reference = rtrim(@Chaine)+'P'
IF (@vNumeroPromo=8)
select @DFin = SUBSTRING(CAST(CONVERT(DECIMAL (13,7),PrixSolde8) AS VARCHAR),8,6)
from solde
where reference = rtrim(@Chaine)+'P'
IF (@vNumeroPromo=9)
select @DFin = SUBSTRING(CAST(CONVERT(DECIMAL (13,7),PrixSolde9) AS VARCHAR),8,6)
from solde
where reference = rtrim(@Chaine)+'P'
IF (@vNumeroPromo=10)
select @DFin = SUBSTRING(CAST(CONVERT(DECIMAL (13,7),PrixSolde10) AS VARCHAR),8,6)
from solde
where reference = rtrim(@Chaine)+'P'
SET @DFin = substring(@DFin,1, 6)
SET @DFinJ = substring(@DFin,1,2)+'/'
SET @DFinM = substring(@DFin,3,2)+'/'
SET @DFinA = substring(@DFin,5,2)
SET @DFin = @DFinJ+@DFinM+'20'+@DFinA
RETURN (@DFin)
END |
Partager