@bmg002,

Well i have 1 millions on customers and 14900 on customers history.

The first query that i share was speedy , i did a second query and better and looks like...

Hi @bmg002,

Unfortunately i didn't fixed it yet i need some help on that too

I launched the query and it takes about 1h28 min , i think it's a lot ..

Hi @bmg002,

Thank you for your time.

Yes i am agree with your comment , also it is not expected to me in that case i need to take the value from...

Hi @bmg002

Thanks for replying .

I did a query but it doesn't look like efficient and need to add some code to complete it .

Like i said the idea is following...

• This reply was modified 1 year, 8 months ago by MrRobot.

Hello @scdecade

Thanks for replying.Well i see the query but it didn't give me the expected result.

Well, i did a query that give the right result just one case it's wrong...

@phil-parkin just the text but the question isn't same

Hello @phil-parkin

Not the seem the output is different

Hello @phil-parkin

Thanks for your help.

Your solution resolve the problem with the sample that i give but i executed with other data i got some wrong result

@scdecade Thanks for replying

base on you query is there away to display someting like that :

• This reply was modified 1 year, 9 months ago by MrRobot.
• This reply was modified 1 year, 9 months ago by MrRobot.
• This reply was modified 1 year, 9 months ago by MrRobot.

Hello @Phil Parkin

Thanks for replying

Like a said in the post

To identify a left package (not collected by customer) the status need to be ("Dropoff" or "preparation") OR ("Dropoff" or "preparation") and after...

Thanks for the answer

As bellow the result of query

Hello Jonathan,

The table 1 is a fact table and the table 3 is a dimension table the t1_Key is a foreign key of the table 3 , like a said...

Hello,

YEs the output that you did is correct this what i want

Thanks

Hi,

Just to answer to your question about why i have int date because it's a fact table ,

Thanks for new code. I will test that in my sample data then...

• This reply was modified 3 years, 2 months ago by MrRobot.

Hi,

I did the query as bellow i don't know if will perfectly work for another data but with my sample data is work fine just one problem when i do...

• This reply was modified 3 years, 2 months ago by MrRobot.