Search results for query: *

Hi all, I am attempting to write a query that will get me all of the transactions for a warehouse from the time it finished its year end inventory count until the actual fiscal year end. Because of staff resourcing issues we had to count/inventory each warehouse on a different day and so many...

Thanks very much George for your solution and explanations. Everything is working great with your much more concise piece of code. Shaun

Hi all, I have written a piece of SQL code that is retrieving active stock numbers from our inventory system and is indicating across the columns if the item is stocked in each of our warehouses. The code currently works, but I am hoping to find a more elegant solution and possibly one that...

Hi all, I am trying to have Discoverer run a very simple query, but it doesn't seem to allow me to run multiple counts within the same report. The below code was written in SQL Developer and I want to recreate it in Discoverer. I am just simply trying to get a count of the number of POs and...

Thanks as well to SQLSister. I got rid of all of the parentheses as well as the semi-colon. Also, removing the subselect seemed to speed up the query and removing DISTINCT helped as well. It definitely wasn't necessary in this case. Anyway, thanks again to both of you. It seems to be...

Thanks pwise!

Hi all, I have written the SQL statement below which shows me item information for items ordered within the time frame specified within the subquery. The issue I am having is that I am actually looking for the items that have NOT been ordered, but changing the first part of my WHERE statement...