Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Dave,
Check this thread in regards to the IntervalMatch() loading, that links a range table with a discrete value table.
Hope that helps.
BI Consultant