SQL Query to get Absence Entry Details which makes the plan balance negative
Summary
SQL Query to get Absence Entry Details which makes the plan balance negativeContent
Hi Experts, Wondering if any of you have a SQL query handy which gives details of an absence entry which makes the balance go into negative. Say for example an employee has 10 days of balance on a given day. He books one absence for 8 days and second for 4 days. Now the second absence of 4 days is taking the balance to negative. is it possible to get the details of the second absence along with the amount value by which the balance has gone into negative. For this example the amount value is 2. Any help/pointer is
Tagged:
1