EXEC sp_executesql with multiple parameters

Question

How to pass the parameters to the EXEC sp_executesql statement correctly?

This is what I have now, but i'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'select   SentToLab, FROM     dbo.vEmailSent WHERE     SentToLab_ID=@LabID and convert(date,DateSent) >= @BeginDate  and CONVERT(date, datesent) <= @EndDate and RequestType_ID in ( @RequestTypeID )  EXEC sp_executesql  @statement,N'@LabID int',  @LabID, N'@BeginDate date', @BeginDate,N'@EndDate date', @EndDate, @RequestTypeID=@RequestTypeID  END 

RequestTypeID is a comma delimited list of integers, like so: "1,2,3,4,5"

here is my try #2, also unsuccessful

declare @statement nvarchar(4000)  SET @statement =' select    SentToLab_ID  FROM     dbo.vEmailSent WHERE      SentToLab_ID='+@LabID+' and convert(date,DateSent) >= '+@BeginDate +' and CONVERT(date, datesent) <= '+@EndDate+' and RequestType_ID in ('+ @RequestTypeID+' ) group by FileStream_ID, SentToLab_ID'   EXEC(@statement) 

Operand type clash: date is incompatible with int

Answer 1

Here is a simple example:

EXEC sp_executesql @sql, N'@p1 INT, @p2 INT, @p3 INT', @p1, @p2, @p3; 

Your call will be something like this

EXEC sp_executesql @statement, N'@LabID int, @BeginDate date, @EndDate date, @RequestTypeID varchar', @LabID, @BeginDate, @EndDate, @RequestTypeID