Hi,

I am having 5 columns as below.

Now I want to update selected data only depend upon lunch time. for example if lunch time of StuID 1 is between 1AM to 11AM then i want to set flag = 1.thus it will update 4 rows.

StuID EffectiveDate StartTime EndTimeFlag

12013-04-03 00:00:00.000 8:00AM 8:15AM0

12013-04-03 00:00:00.000 8:15AM 8:30AM0

12013-04-03 00:00:00.000 8:30AM 8:45AM0

12013-04-03 00:00:00.000 8:45AM 9:00AM0

12013-04-03 00:00:00.000 9:00AM 9:15AM0

12013-04-03 00:00:00.000 9:15AM 9:30AM0

12013-04-03 00:00:00.000 9:30AM 9:45AM0

12013-04-03 00:00:00.000 9:45AM10:00AM0

12013-04-03 00:00:00.00010:00AM10:15AM0

12013-04-03 00:00:00.00010:15AM10:30AM0

12013-04-03 00:00:00.00010:30AM10:45AM0

12013-04-03 00:00:00.00010:45AM11:00AM0

12013-04-03 00:00:00.00011:00AM11:15AM0

12013-04-03 00:00:00.00011:15AM11:30AM0

12013-04-02 00:00:00.000 1:00PM 1:15PM0

12013-04-02 00:00:00.00012:45PM 1:00PM0

12013-04-02 00:00:00.00012:30PM12:45PM0

12013-04-02 00:00:00.00012:15PM12:30PM0

12013-04-02 00:00:00.000 8:00AM 8:15AM0

thanks

Abhas.