thanks a lot.

is it possible for procedure to have 02 output parameters?

how can i do it? and use them

Merci, it's works!

thanks

PS: how to sate that a post is closed or solved?

hi,

MERCI

gracias.....

hi,

so i should write begin transaction instead of begin ...and end transaction at the end???

Merci

I do not look that way

I have made it

hi,

i am using MSsql server management studio

Is that wizard integrated?

i have looked all over and i can't find it

thx

hi how do we mark that a question has been solve?

thx

Hi,

I found the error,

I have miswrite an instruction so i have corrected it

so instead of WHERE CSR_DOSSIER.DOS_ID = CSR_STATUT.sta_id

i have corrected to WHERE CSR_DOSSIER.DOS_ID = CSR_STATUT.DOS_ID

thanks..

there is the full error statement

Msg 206, Level 16, State 2, Procedure DossierStatut, Line 16

Conflit de types d'opérandes : uniqueidentifier est incompatible avec int

sorry is in french

there is the full code

se [RECLACSR-DB]

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author:<Author,,Name>

-- Create date: <Create Date,,>

-- Description:<Description,,>

-- =============================================

CREATE PROCEDURE dbo.DossierStatut

-- Add the parameters for the stored procedure here

@Node nvarchar...

the error is locate just here

AND dbo .CSR_DOSSIER.DOS_ID =(SELECT dbo.CSR_DOSSIER.DOS_ID

FROM dbo.CSR_DOSSIER WHERE DOS_NODE =@node )

i can t understand

thanks!!

It OK

hi,

Yes it does!!!

thks