SQL for the Calculation Card - Benefits and Pensions for UK
Summary:
SQL query needed for the Benefits and Pensions Calculation Card for UK
If an employee is having Active and Inactive Assignment and the components which are associated to the Inactive Assignments need to be Excluded from the sql output.
We have an sql which is fetching the component which is associated to the Inactive assignment also.
sql file attached.
Tagged:
0