>>Please take the time to mark her message as the solution so others can learn by it.
>>
>>Thanks!
>
>BTW, I corrected again my version - Jim, please review the procedure. I think we do need to use different variables - e.g. in the second version I changed them to InnerStartDate, etc. again - I either got confused too much or something was not working in my tests properly.
Here is the completed sp.

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		ATSI
-- Create date: 11/5/2009
-- Description:	Procedure to retrieve all data from the selected table between the selected dates
-- =============================================
ALTER PROCEDURE [dbo].[GetWellData] 
	-- Add the parameters for the stored procedure here	
	@Tablename sysname,
	@StartDate as datetime,
	@EndDate as datetime

AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from interfering with SELECT statements.
	SET NOCOUNT ON;

	Declare @cmd AS NVARCHAR(max)
	Declare @ParamDefinition NVARCHAR(500)

	SET @ParamDefinition = N'@StartDate datetime, @EndDate datetime'
	SET @cmd = N'Select * from ' + QUOTENAME(@TableName) + 'WHERE Date between @StartDate And @EndDate'
    
	exec sp_executesql @cmd, @ParamDefinition,
		@StartDate = @StartDate,
		@EndDate = @EndDate
END