• Here is the corrected version:

    CREATE PROCEDURE [ENREGISTRERREJET]

    -- Add the parameters for the stored procedure here

    @RejID UNIQUEIDENTIFIER = '00000000-0000-0000-0000-000000000000' OUTPUT,

    @numdde NCHAR (10),

    @rejetStatut NCHAR(50)=3,

    @sceorigine NVARCHAR (1)=NULL,

    @motifrejet INT=1,

    @stadde INT=1,

    @comment NVARCHAR (200)='RAS',

    @Traitement NVARCHAR (50)='EnregistrerRejet',

    @Destinataire NVARCHAR (50)=NULL,

    @Observation NVARCHAR (200)=NULL,

    @ObjeRempli NVARCHAR (200)=NULL,

    @RefCourrier NVARCHAR(50)=NULL

    AS

    BEGIN

    -- SET NOCOUNT ON added to prevent extra result sets from

    -- interfering with SELECT statements.

    SET NOCOUNT ON;

    IF @RejID IS NULL

    OR @RejID = '00000000-0000-0000-0000-000000000000'

    BEGIN

    SET @RejID = NEWID()

    END

    -- Insert statements for procedure here

    IF NOT EXISTS (SELECT *

    FROM dbo.CSR_REJET

    WHERE DOS_NODE = @numdde)

    BEGIN

    INSERT INTO dbo.CSR_REJET

    (REJ_ID,

    DOS_NODE,

    REJ_SVCORIG,

    MRE_CODE,

    REJ_CMT,

    REJ_STATUT,

    REJ_DTREC)

    VALUES (@RejID,

    @numdde,

    UPPER (@sceorigine),

    @motifrejet,

    @comment,

    @rejetStatut,

    CAST(FLOOR(CAST(CURRENT_TIMESTAMP AS FLOAT)) AS DATETIME) )

    ----MAJ de la table des statut

    UPDATE CSR_STATUT

    SET STA_ID = @stadde,

    STA_DATE = CAST(FLOOR (CAST (CURRENT_TIMESTAMP AS FLOAT)) AS DATETIME)

    WHERE DOS_ID = (SELECT dbo.CSR_DOSSIER.DOS_ID

    FROM dbo.CSR_DOSSIER

    WHERE DOS_NODE = @numdde)

    END

    ELSE

    BEGIN

    IF ( @Traitement = 'EnregistrerRejet' )

    BEGIN

    UPDATE dbo.CSR_REJET

    SET REJ_SVCORIG = UPPER (@sceorigine),

    MRE_CODE = @motifrejet,

    REJ_CMT = @comment,

    REJ_STATUT = @rejetStatut,

    REJ_DTREC = CAST(FLOOR(CAST(CURRENT_TIMESTAMP AS FLOAT)) AS DATETIME)

    WHERE DOS_NODE = @numdde

    END

    ELSE

    IF ( @Traitement = 'Transmettre' )

    BEGIN

    UPDATE CSR_REJET

    SET REJ_SVCDEST = UPPER (@Destinataire),

    REJ_OBS = @Observation,

    REJ_STATUT = @rejetStatut,

    REJ_DATETRT = CAST (FLOOR (CAST (CURRENT_TIMESTAMP AS FLOAT)) AS DATETIME)

    WHERE DOS_NODE = @numdde

    END

    ELSE

    IF ( @Traitement = 'Archiver' )

    BEGIN

    UPDATE CSR_REJET

    SET REJ_OBS = @Observation,

    REJ_STATUT = @rejetStatut,

    REJ_DATETRT = CAST (FLOOR (CAST (CURRENT_TIMESTAMP AS FLOAT)) AS DATETIME)

    WHERE DOS_NODE = @numdde

    ----MAJ table csr_statut

    UPDATE CSR_STATUT

    SET STA_ID = @stadde,

    STA_DATE = CAST(FLOOR(CAST(CURRENT_TIMESTAMP AS FLOAT)) AS DATETIME)

    WHERE DOS_ID = (SELECT DOS_ID

    FROM CSR_DOSSIER

    WHERE DOS_NODE = @numdde)

    END

    ELSE

    IF ( @Traitement = 'ObjetRempli' )

    BEGIN

    UPDATE CSR_REJET

    SET REJ_OBS = @Observation,

    REJ_OBJREJ = @ObjeRempli,

    REJ_STATUT = @rejetStatut,

    REJ_DATETRT = CAST (FLOOR (CAST (CURRENT_TIMESTAMP AS FLOAT)) AS DATETIME)

    WHERE DOS_NODE = @numdde

    ----MAJ table csr_statut

    UPDATE CSR_STATUT

    SET STA_ID = @stadde,

    STA_DATE = CAST(FLOOR(CAST(CURRENT_TIMESTAMP AS FLOAT)) AS DATETIME)

    WHERE DOS_ID = (SELECT DOS_ID

    FROM CSR_DOSSIER

    WHERE DOS_NODE = @numdde)

    END

    ELSE

    IF ( @Traitement = 'Imprimer' )

    BEGIN

    UPDATE CSR_REJET

    SET REJ_DATRANS = CAST (FLOOR (CAST (CURRENT_TIMESTAMP AS FLOAT)) AS DATETIME),

    REJ_RefCourrier = @RefCourrier

    WHERE DOS_NODE = @numdde

    AND REJ_ID = @RejID

    DECLARE @dt DATETIME = CAST (FLOOR (CAST (CURRENT_TIMESTAMP AS FLOAT)) AS DATETIME)

    EXEC dbo.CREERFILE

    '00000000-0000-0000-0000-000000000000',

    @RefCourrier,

    @dt

    END

    END

    END

    ~ Lokesh Vij


    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter