>>>>>I didn't look too close yet, but looks like there is an extra comma at the end of cmd line - not sure how did it get there.
>>>>
>>>>Right, I took out the extra commas, and it saved successfully, but when I tried to run it, I get this:
>>>>
>>>>Must declare the scalar variable "@StartDate".
>>>
>>>Getting this error right now - give me a sec.
>>
>>Of course!!!
>>
>>Here is the correct version
>>
>>

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

Please take the time to mark her message as the solution so others can learn by it.

Thanks!