Hello Drew,

I've been at it for a few hours not, but I can't find the 3rd problem you're talking about. I've also been testing more sample data and everything is...

Hey Drew,

Thanks again for your feedback. I understand where you're coming from and believe me I really want to learn, I'm not looking for someone to just hand me all...

Hello Jacob,

Thanks a lot for your reply. I ran this query on the live database and got about 360 records returned which sounds about right. I have checked 35 so...

Ohhh I see what you mean. I mean the rows of interest are being ordered by TransType Desc and by TransDate Desc, but that leaves out the TransType =1 according...

Hello Drew,

I did look at the results I'm getting over and over and I'm trying to understand what the ROW_NUMBER() is doing, but I'm a little lost. I see it's...

Hello Jacob,

I have the results I want from the dataset provide, but not sure how to show them in table view on here.

lotnoitemnodescwarehousecurrentqtycosttransdatetranstypetransqty

005965001TEQU0110 ...

Hello Guys,

I generated a sample from the actual live database. Please note that the TransType on the database is stored as follows:

TransType: 4 = Shipment

TransType: 1 = Receipt

I put...

Hello Drew,

I apologize I didn't make it clearer. The CurrentQty > 0 should apply to the entire recordset whether it is a shipment or receipt.

Hello Guys,

I'm really sorry for all the confusion this has caused. It is true, I'm not a SQL expert so I don't fully understand what the ROW_NUMBER() expression does yet,...

Hello Drew,

I was out for a few days. I'm back to work today. I'm sad to report that your solution doesn't produce the correct results when I put it on...

Oh WOW this works PERFECTLY!!!! Thank you sooooo much Drew, and the other guys for your input. I have been breaking my head with this for weeks before posting it....

Hey SSCrazy,

Thank you so much, that's exactly the results I'm looking for. If I could just get the query's logic to do this work it would be amazing. Thanks a...

Hello Drew,

Thank you so much for sticking around to help, I'm learning SQL as well as how to use the forum as I go. I realized I made a mistake,...

Hello Drew,

I replaced the variables with my table names (which are saved and contain data) on my SQL Server, but it does not work. I get "Invalid object name" for...

Hello Drew,

Thanks for your reply. I see that your code starts with:

;

WITH

I'm getting an error saying that the variable, is some of your code missing?

Also, I included the image...