| Erreur : Invalid length parameter passed to the LEFT or SUBSTRING function.
Incorrect syntax near ')'.
select * from
(select nom_institution As Institution , Code_Institution AS [CODE MSPP],v.Description as [Ville],
--Datename(month,DEB_PERIODE) + ' ' + convert(nvarchar(4), year(DEB_PERIODE)) mp,
q.MOIS mp,
--d.DateModif DateModif
case when d.DateModif is null then d.DateCreated else d.DateModif end DateModif
from dbo.QUESTIONNAIRE q
INNER JOIN institution I ON I.ID_INSTITUTION = Q.ID_INSTITUTION
INNER JOIN formulaire f ON F.ID_FORMULAIRE = Q.ID_FORMULAIRE
--INNER JOIN dbo.QUESTIONSFORMULAIRE qf ON qf.ID_Formulaire = q.ID_Formulaire
--INNER JOIN dbo.QUESTIONS qs ON qs.ID_QUESTION = qf.ID_questions
LEFT JOIN dbo.TBL_DATA d ON d.ID_QUESTIONNAIRE = q.ID_QUESTIONNAIRE --AND d.ID_QUESTION = qf.ID_questions
LEFT JOIN dbo.tbl_Departement dept ON I.ID_Departement = dept.id_departement
LEFT JOIN TBL_Ville V on v.id_ville = i.ID_Ville
where
f.ID_services = 14 and i.ID_bailleur = 1 and
DEB_PERIODE >= 'May 1 2025 ' and
DEB_PERIODE < 'May 31 2025 ' ) p1
PIVOT (max(DateModif) FOR mp IN ()) p2 Order By Institution |
|
En Cours(Saisie) :
|
|
En validation :
|
|
Publié :
|
|
Retourné :
|
|
Erreur
|
|
Questionnaire vierge ou non planifié :[
|
-
|
-
|
]
|
|
|
|