NO Code In Out date shift Absent/Present
63089 2 9:00 18:00 2018-11-28 00:00:00.000 0 G P
63090 2 9:00 18:00 2018-11-29 00:00:00.000 0 G P
63091 2 9:00 18:00 2018-11-30 00:00:00.000 0 G P
i have G A B C shits so need to rotational chage based on date in sql or C#
please help me