Thx Frank ! Your solution is better for performance i think.

K good it works ! I've found the solution :

DECLARE @Where varchar(1000)

CREATE TABLE #Temp (Nb int)

SET @Where = ' ABO_ID =' + Cast(@aboId as varchar) + ' and SITE_ID...

Ok- Thx

But have you got a sample code to do this ?

Thx again

Ok. thx a lot.

Well my original SP is :

ALTER  PROCEDURE MYPROC(@idSite int, @Type varchar(4)) AS

DECLARE @strReq varchar(1000)

SET @strReq = 'SELECT  DLZ_EMAIL.EMAIL_LIB, COUNT(*) AS nb_email

     FROM DLZ_EMAIL  WHERE DLZ_EMAIL.DATE_DEB <=GETDATE() '

If @Type='HTML'

 begin

  SET...

And for my second question have you got an idee?

'cos i can't do this :

SET @strReq = 'SELECT  DLZ_EMAIL.EMAIL_LIB, @nb-2 = COUNT(*)

     FROM DLZ_EMAIL  WHERE DLZ_EMAIL.DATE_DEB <= GETDATE()'

@nb-2...

Oh YES !!! It works !

I believed that a CAST had to be made.

Thx a lot SQLBill ... I'm so stupid )))))

SQLBill:

'cos when i just do :

SET @strReq = 'SELECT  DLZ_EMAIL.EMAIL_LIB, COUNT(*) AS nb_email

     FROM DLZ_EMAIL  WHERE DLZ_EMAIL.DATE_DEB <=' + GETDATE()

it tellls me the same message : "Syntax error converting datetime...