ALTER proc [dbo].[sp_chart1](@from as varchar(30),@to as varchar(30)) as begin DECLARE @ft datetime DECLARE @tt datetime set @ft=CONVERT(datetime,@from) set @tt=CONVERT(datetime,@to) CREATE VIEW VIEW11 AS SELECT Time_Sheet.entry_by,Time_Sheet.duration,Module_Master.module_name FROM Time_Sheet INNER JOIN Module_Master ON Time_Sheet.module_id=Module_Master.module_id where Time_Sheet.create_date>=@ft and Time_Sheet.create_date<=@tt end
SELECT ... FROM VIEW11 WHERE Time_Sheet.create_date>=@ft AND Time_Sheet.create_date<=@tt
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)