How to pass the parameters to the `EXEC sp_executesql` statement correctly? 

This is what I have now, but i&#39;m getting errors:

    alter PROCEDURE [dbo].[usp_getReceivedCases]
    	-- Add the parameters for the stored procedure here
    	@LabID int,
    	@RequestTypeID varchar(max),
    	@BeginDate date,
    	@EndDate date
    AS
    BEGIN
    	-- SET NOCOUNT ON added to prevent extra result sets from
    	-- interfering with SELECT statements.
    	SET NOCOUNT ON;
    
    
    declare @statement nvarchar(4000)
    
    set @statement = N&#39;select   SentToLab,
    FROM     dbo.vEmailSent
    WHERE     SentToLab_ID=@LabID and convert(date,DateSent) &gt;= @BeginDate 
    and CONVERT(date, datesent) &lt;= @EndDate
    and RequestType_ID in ( @RequestTypeID )
    
    EXEC sp_executesql  @statement,N&#39;@LabID int&#39;,  @LabID, N&#39;@BeginDate date&#39;, @BeginDate,N&#39;@EndDate date&#39;, @EndDate, @RequestTypeID=@RequestTypeID

    END



RequestTypeID  is a comma delimited list of integers, like so: &quot;1,2,3,4,5&quot;


here is my try #2, also unsuccessful

    declare @statement nvarchar(4000)

    SET @statement =&#39; select    SentToLab_ID
     
    FROM     dbo.vEmailSent
    WHERE     
    SentToLab_ID=&#39;+@LabID+&#39; and convert(date,DateSent) &gt;= &#39;+@BeginDate +&#39;
    and CONVERT(date, datesent) &lt;= &#39;+@EndDate+&#39;
    and RequestType_ID in (&#39;+ @RequestTypeID+&#39; )
    group by FileStream_ID, SentToLab_ID&#39;
    
    
    EXEC(@statement)

    

&gt; Operand type clash: date is incompatible with int




All Sp Executesql Solutions on Gang of Coders

Total of 1 Sp Executesql Solutions

EXEC sp_executesql with multiple parameters