>>-- Test query >>alter PROCEDURE [dbo].[GetWellData] >> -- Add the parameters for the stored procedure here >> @Tablename sysname, >> @StartDate datetime, >> @EndDate datetime >>AS >>BEGIN >> -- SET NOCOUNT ON added to prevent extra result sets from interfering with SELECT statements. >> SET NOCOUNT ON; >> SET @TableName = RTRIM(@TableName) >> >> Declare @cmd AS NVARCHAR(max) >> DECLARE @ParmDefinition NVARCHAR(500) >> SET @ParmDefinition = N'@StartDate datetime ,@EndDate datetime' >> >> SET @cmd = N'Select * from ' + QUOTENAME(@TableName) + ' where BidDateTime between @StartDate and @EndDate' >> >> exec sp_executesql @cmd, @ParmDefinition, >> @StartDate = @StartDate, >> @EndDate = @EndDate >>END >>go >> >>execute GetWellData 'Bid', '20081001','20091101'> That did it, Thanks Naomi.