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) --SET @StartDate = RTRIM(@StartDate) --SET @EndDate = RTRIM(@EndDate) Declare @cmd AS NVARCHAR(max) SET @cmd = N'Select * from ' + QUOTENAME(@TableName); exec sp_executesql @cmd; END