| 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,
userLog.User_ID ModifBy
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
LEFT JOIN dbo.tbl_S_UserLog userLog ON q.ID_QUESTIONNAIRE = userLog.id_object
where
userLog.type_object = 'questionnaire' and
userLog.Activity = 'Poster questionnaire' and
f.ID_services = 2 and i.ID_bailleur = 1 and
DEB_PERIODE >= 'Sep 1 2024 ' and
DEB_PERIODE < 'Oct 31 2024 ' ) p1
PIVOT (max(ModifBy) FOR mp IN ()) p2 Order By Institution |
|
En Cours(Saisie) :
|
|
En validation :
|
|
Publié :
|
|
Retourné :
|
|
Erreur
|
|
Questionnaire vierge ou non planifié :[
|
-
|
-
|
]
|
|
|
|