1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[PS_REMPLIR_GRILLE_PRODEMANDE]
@Profil int
AS
BEGIN
DECLARE @Script varchar(8000)
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 = + @Profil'
SET @Script = @Script
EXEC(@Script)
END |
Partager