1 2 3 4 5 6 7 8 9 10
|
SELECT DISTINCT TF_FAI_Faits.FAI_Periode Valeur
, UPPER(LEFT(Datename(Month,CONVERT(date, CAST(FAI_Periode AS varchar(6))+'01',112)),1))
+ Right(Datename(Month,CONVERT(date, CAST(FAI_Periode AS varchar(6))+'01',112)), len(Datename(Month,CONVERT(date, CAST(FAI_Periode AS varchar(6))+'01',112)))-1)
+ ' ' + LEFT(CAST(FAI_Periode AS varchar(6)), 4) Label
FROM TOTO INNER JOIN
TR_COL_Colonne ON TF_FAI_Faits.COL_Code = TR_COL_Colonne.COL_Code
WHERE TR_COL_Colonne.COL_Libelle <> '13 Mois'
ORDER BY TF_FAI_Faits.FAI_Periode DESC |
Partager