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 strongm 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: mpatter5
  • Content: Threads
  • Order by date
  1. mpatter5

    Should be simple SQL problem

    I have what seems like a simple problem, but I can't seem to figure it out. As an example, I have the following db2 table: Table = TESTB MO NUM 1 8 2 40 3 16 4 25 5 36 6 2 I need to find the following values in a single query: min(num) = 2 max(num) = 40 sum(num) =...
  2. mpatter5

    QMF Report Center - Append Data To Excel?

    DB2 v8.1.10.812 FixPak 10 Windows XP Professional 2002 Service Pack 2 I want to be able to append data each time a QMF query is automatically run from QMF Report Center to a specific Excel worksheet in a specific Excel workbook so that previously existing data in the worksheet is added to and...
  3. mpatter5

    Access Query to List First Day of Each Week in Year

    I have a DB2 query that lists the first day of each week in a year. I need to be able to convert this to an Access query. Here's the DB2 query: with all_days(dt) as (select (date('2007-01-01')) from sysibm.sysdummy1 union all select dt + 1 day from all_days...

Part and Inventory Search

Back
Top