Basically I'm trying to achieve MTD and YTD Transactions.
With Join 1#, I see your suggestion will work
Similarly Join 2#,If the Master table 1 is looking at Feb Month end, From Transaction, i would like to get all transactions until Feb end.
If I choose Oct from Master Month end,Then all transactions until Oct from Historical table.
I'm guessing I could join by using <= or something.
But my real question is,
Can I maintain two different Physical tables and create views (Create different results set by combining both tables using different joins )
Let me Ask this in a different way.
1)Job Opening Table, That has Hiring Manager ID and Recruiter ID.
2)Hiearchy Table: That has denormalized view with all the levels
I would like to set relations as
1 )Job Opening Table Hiring Manager ID + Emplid in Hierarchy table
2) Job Opening Table Recruiter ID + Emplid in Hierarchy table