1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
|
DECLARE @ParmDefinition nvarchar(500)
DECLARE @Script varchar(8000)
SET @ParmDefinition = N'@ProfilUsed int'
SET @Script = 'SELECT DISTINCT DEMANDE_INTERVENTION.IdDemande_PK , DEMANDE_INTERVENTION.Objet ,
DEMANDE_INTERVENTION.DteDemande , DEMANDE_INTERVENTION.DteDebut ,
DEMANDE_INTERVENTION.DteFin, DEMANDE_INTERVENTION.NomDemandeur, DEMANDE_INTERVENTION.PrenomDemandeur,
DEMANDE_INTERVENTION.IdClient_FK,DEMANDE_INTERVENTION.IdStatut_FK, DEMANDE_INTERVENTION.Observations
FROM DEMANDE_INTERVENTION inner join STATUT inner join PROFIL_STATUT
ON STATUT.IdStatut_PK = PROFIL_STATUT.IdStatut_FK
ON DEMANDE_INTERVENTION.IdStatut_FK = PROFIL_STATUT.IdStatut_FK
WHERE PROFIL_STATUT.IdProfil_FK = @ProfilUsed'
EXECUTE sp_executesql @Script , @ParmDefinition,
@ProfilUsed = @Profil; |
Partager