SQL Experts,  Any help is appreciated!

Hello Expert,

The query performed perfectly, but I had to account for specific cases where it didn't work as expected. Some transactions have reversals. For instance, consider the scenario where the...

Thank you so much Steve and Fahey Jonathan!  Both queries works perfect.

Hi bmg002 , Thanks for your support.

I managed to assign numeric values for the memType column.  Your query works as long as they are in ascending order.  If I had...

Any help is greatly appreciated!

Appreciate both of your responses.

I can manage to bring in the time factor so that part will be covered.

Regarding the type , i used some sample data.  But, it is...

Ha! Sounds good!

Thank you very much!

OH yes, the gcode is actually 14 character value (for testing I minimized it).  Is there a way.

Also, I have a requirement for 2 as well on the...

Thanks Scott, that was my bad, yes p1 and p3 should be there.  This works.  In real world I am going against millions of records with lot of columns in...

Each order are different, they are not related.  For this sample data purpose it is ok to assume 1 item for each order.

Also, this statement might help.

"If 60 days has passed since that 1st order with received qty=0 and all orders submitted within 60 days of the 1st order have...

Thank you very much for the response.  There is one scenario I forgot to add, assumed the 60 days will address that.   Item3 should be accounted even if it was...

This works great!  Thank you so much Linksup!

Thanks for the query, it's my bad on the data.

I see one issue, when the manufacturer man1's amount invoice (amountI) is the highest for both flags then the...

Thank you so much Drew and Steve.  I will run against real-time data and see.  Works perfect with the test data.