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!

  • Congratulations biv343 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: d000hg
  • Content: Threads
  • Order by date
  1. d000hg

    For each value in one table, select nearest value in another table

    This is pretty simple to describe: Table A & B both have a date field. I need a query/procedure which will do: SELECT A.date, { max(B.date) where B.date < A.date} Example: A.date.... B.date ======.... ====== 10/10/2006 01/01/1999 01/04/2007 12/12/2006 Result: A.date | Max B.date < A.date...
  2. d000hg

    Table acting as dimension and fact - ugly.

    Imagine you want to load to a DW something like the number of minutes spent by a person on a project. The obvious interpretation is that the measurable fact is the number of minutes, and the person and the project should be the dimensions. But what if you also need to load the projects into the...
  3. d000hg

    A couple of questions about populating a Data Warehouse

    Hi there. I'm new here so if my questions are already answered please let me know. Anyway, two questions about loading data into a DW from the operational process databases: 1)Do we normally update the DW each time the operational DBs are modified? i.e when a sale is made would the DW be...

Part and Inventory Search

Back
Top