if an order changes multiple times before it is shipped, the original quantity is always going to be the last quantity to what it was changed last.

example

--------------

order quantity

40000

--------------

1st change

36000

--------------

2nd...

Hi.

The code that you gave me (the link) worked. After that I needed to add one more cte I think.

And adjustment to catch orders like

S20026, the order begins...

Hi,

I know I went back and forth with this question several times, but it would be really great if you would help me a last time because I can't...

i forgot to upload the stored procedure yesterday

Are you asking for the stored procedure after I added your code?

What I tired so far was to modified the CASE statement where the Filled Rate gets calculated:

CASE

...

Honestly, your last code was awesome, I just replaced the "Sample Orders" part with the sub-query that I use to get the data and it gave me excellent results right...

J Livingston SQL, you are a life saver sir.

I have a question about something I noticed, and this is probably a communication flaw of mine.

Using the data I...

i am getting nowhere :/

whenever you have time, i would appreciate any help.

thank you

Thank you for your response.

I will continue to try make it work.

Once question if possible, if I want to store the results of the working query in a...

Hi, I was wondering if the post I made sort of were clear. I have been working on the query myself trying to get to that quantity but still no...

what row are you expecting to see the fill factor...please provide example.

the filled rate should go in the last row, that is the last version of an order row....

Hello and thank you for your help.

Your query works very well for what I need it to do.

I am not approaching to our NAV vendor because I wanted...

I am uploading the script and sample output file as requested.

Thank you for your help.

Down below is the SQL that creates the "Orders" table. It includes every version of an Order. In the code below, I used it to retrieve Order S20026. I returns...

I would like to try your code against my real tables, but how would I replace Orders? that is a table I just created to provide as an example.

When I...