Forum Discussion

andrewpirie's avatar
andrewpirie
Icon for Resolver II rankResolver II
8 years ago
Solved

Joining/Merging where TABLE1.DateTime is between TABLE2.StartDateTime and TABLE2.EndDateTime

I have a table named "SnapshotDateTimes" with a column ReferenceDateTime.   I have another table that holds snapshotted data of a customer record, and a column that identifies the from and two date...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi andrewpirie,


    Nope, I don't think it is possible.


    These tables has relationship with expand date range which not real existed in table column, you need to create new column to store fully detail range dates to link two tables.

     

    Maybe you can try to use T-sql to create this template link table.

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi andrewpirie,


Nope, I don't think it is possible.


These tables has relationship with expand date range which not real existed in table column, you need to create new column to store fully detail range dates to link two tables.

 

Maybe you can try to use T-sql to create this template link table.

 

Regards,

Xiaoxin Sheng

  • andrewpirie's avatar
    andrewpirie
    Icon for Resolver II rankResolver II
    8 years ago

    Thanks Anonymous - it's great to have an experienced answer on this, I'll try another optimization technique instead of going in circles on this one :).

     

    Andrew