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,
END
END
END
~ Lokesh Vij
Link to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter