ALTER PROCEDURE [dbo].[sp_getVisitCountByDate] @TableName varchar(50), @StartDate datetime, @EndDate datetimeAS BEGIN SET NOCOUNT ON; Declare @sql nvarchar(1000); SET @sql = 'SELECT * from ' + @TableName + ' where VisitDate between '''+ Convert(varchar(50),@StartDate,120) +''' and '''+Convert(varchar(50),@EndDate,120) + '''' exec(@sql) END
@TableName varchar(50),
@StartDate datetime,
@EndDate datetimeAS
BEGIN
SET NOCOUNT ON;
Declare @sql nvarchar(1000);
SET @sql = 'SELECT * from ' + @TableName + ' where VisitDate between '''+ Convert(varchar(50),@StartDate,120) +''' and '''+Convert(varchar(50),@EndDate,120) + ''''
exec(@sql)
END