Hi Matak,

My Procedure is like

ALTER PROCEDURE [dbo].[Usp_UpdateLunchTime]

@StuID INT,

@StartDate datetime,

@EndDate datetime,

@StartTime varchar(20),

@EndTime varchar(20)

--@LunchStart varchar(20),

--@LunchEnd varchar(20)

--@DayName varchar(100),

AS

BEGIN

update tblTime set flag = 1

where StuID = @StuID and EffectiveDate =@StartDate

and StartTime between right(Convert(char(20), @StartDate,100),7) and right(Convert(char(20), @EndDate,100),7)

--CONVERT(VARCHAR(10), EffectiveDate, 110) between CONVERT(VARCHAR(10), @StartDate, 110) and CONVERT(VARCHAR(10), @EndDate, 110)

--exec Usp_UpdateLunchTime 1,'2013-04-01 00:00:00.000','2013-04-05 00:00:00.000','2013-04-01 07:00:00.000','2013-04-01 20:00:00.000'

END

Thanks

Abhas.