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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mpatter5

  1. mpatter5

    Should be simple SQL problem

    WOW!!! That works too... Since the mo field is char datatype in my "Production" db, I tried the following and it seemed to work OK... The (mo) field will always be 6 characters long, but what would you need to do if the field were variable in length? Just make sure that the constant in the...
  2. mpatter5

    Should be simple SQL problem

    Thanks for your response. It worked perfectly. Unfortunately, I am querying some very large tables and performance is a huge issue. Since I only want to read the table once, the following works more efficiently: with TESTB (MO, NUM) as (select 1, 8 from sysibm.sysdummy1 union all select 2...
  3. 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) =...
  4. mpatter5

    QMF Report Center - Append Data To Excel?

    Thanks, Great idea!!! I hadn't thought about consolidating the worksheets using vba, but I think I can work out a solution going that route. Will post my soulution after I've worked through it. Thanks again.
  5. mpatter5

    QMF Report Center - Append Data To Excel?

    Thanks for your response. Report Center is currently set up to execute a QMF query (DB2) at regular intervals and automatically save the data into an Excel workbook. A new worksheet (tab) in the same workbook is created with each run. I want to have 1 worksheet that will contain the data from...
  6. 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...
  7. mpatter5

    Access Query to List First Day of Each Week in Year

    Thanks a million!!! This does exactly what I needed. Can you explain how it works. It give me 143 rows (weeks) through 1/1/2007 thru 9/21/2009. Thanks again...
  8. 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...
See more

Part and Inventory Search

Back
Top