Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Eveyone,
I have a transaction table(Employee details) ,which contains Effective date,i have created a calendar in Transaction table .
History table contains Effective From and Effective To dates,I need to include history table changes to Transaction table.
History table Contains all the fields same as in Transaction table.
Any Suggestions would be greatly appreciated.
Please find the attached sample data for reference.
Regards,
A.Harish
I'm still not sure that I understand what you plan to do with the calendar.
This one creates From/To periods from both your transactions and your historical records (example files from OP). The result is:
See attachment
Peter