>-- 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.