You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!