Linking to Correct Temporal Data

[#1]

Hi,

Can anyone help with with a small issue.  I have an invoice table with invoice date and debt. I also have a full temporal table of account holder.

What I am trying to do is join the 2 tables together where the invoice date is between the effective_start and effective_end on the account holder table.

Any assistance would be greatfully received

[Miguel_Angel_Baeyens]

Hi Dave,

Check this thread in regards to the IntervalMatch() loading, that links a range table with a discrete value table.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica