Interval Match

[#1]

Hey Guys.

Can anyone give me a good basic example of an interval match? Ive searched the forums but all the ones I came accross were a bit to confusing for me. I want to try and use Interval Match in one of my projects but I don't understand it properly.

[martin59]

Hi,

Hope that helps you.

[#3]

very nice, but theres one problem, its French and Im English lol

[martin59]

Sorry, i've forgot it ! I translate it now.

[martin59]

That's it !

[#6]

Thanks for the replies Martin i really appreciate it, however, I'm still not sure what to do to create an interval match. Maybe you can help me?

I want to create an nterval match between two fields, StartDate and EndDate.

LOAD StartDate,

EndDate;

SQL SELECT *

FROM Employee;

This is the first one and this is the second,

LOAD BusinessEntityID,

TerritoryID,

StartDate,

EndDate;

SQL SELECT *

FROM SalesTerritoryHistory;

Any Ideas?

[#7]

Anything?

[martin59]

It's a certification, try to do it yourself.

[#9]

i tried INTERVALMATCH (StartDate,EndDate); SELECT StartDate,EndDate FROM SalesTerritoryHistory; but its not working??

PLEEEEES HELP!!!!

[martin59]

Firstly, you have to use the intervalmatch function with only one argument.

So you have to do something like :

INTERVALMATCH (OrderDate)