Comments by Member 13201220 (Top 2 by date)

Member 13201220 6-Jun-17 1:19am View

Thanks for help everyone.. task completed.

Member 13201220 31-May-17 0:35am View

have logic but not able to implement it.
(for current date to next seven days)
case 1:(for Half-day / Full-day leave) first get the Order_for_date column data from Breakfast table then get LFrom dates from Employee leave table=> Compare both if matched move matched dates data to new table Breakfast cancel.
Case 2 (Casual Leave): get Order_for_date column data from Breakfast table then get LFrom to LTo columns data =>Compare both also consider the dates between 'LFrom to LTo' if matched move to Breakfast cancel table. (EmpCode=Emp_ID). (Breakfast should get cancelled for all the dates for which the employee applied for leaves)

Not able to implement.
suggest if any other way to get this.