Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: hubbsshaun
  • Content: Threads
  • Order by date
  1. hubbsshaun

    Retrieve transactions with different date ranges for each warehouse

    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...
  2. hubbsshaun

    SQL Cross Tab Information

    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...
  3. hubbsshaun

    Count multiple items (Discoverer Desktop Edition 4.1)

    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...
  4. hubbsshaun

    Finding items not ordered in specified time frame

    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...

Part and Inventory Search

Back
Top