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!

Search results for query: *

  1. danisem

    Grandma trying to write sql

    I realized I did not give feedback! Your script was 'plug & play' perfect. I ran in 1 min 19 secs. Thanks so much for the help!
  2. danisem

    Grandma trying to write sql

    Thanks so much for the help! In response to the items you pointed out: The period is originally int in the software it comes from so I just carried that over to the data warehouse. It was an oversight, (bug) on my part for the transaction type and commodity group not to be included as...
  3. danisem

    Grandma trying to write sql

    Sorry, I forgot to answer the nulls. All the columns, except summary_dollars, summary_pounds, and summary_shrinkage_pounds are set to no nulls. There will always be a value for these, even if it is zero. The r_stat table has accumulated transactions since 01/2004 and when I ran the summary...
  4. danisem

    Grandma trying to write sql

    Thanks for the reply. The monthly_recy_summary table has no unique key. The combination of the fields in the where clause seen in the code is what makes each row unique. It is indexed though on the transaction period with a secondary index on transaction period and company. We have started a...
  5. danisem

    Grandma trying to write sql

    I have grandkids twice as young as the last time I programmed with sql. I have written an sql script to update a monthly summary table from a transaction table with 1.5 mil rows. It will eventually be incorporated into a DTS that runs at night. It takes more than 7 hours to run as it is...
  6. danisem

    Crystal reports compatibility

    We currently have historical data in Oracle and we implemented a new operation and accounting system using the Progress database engine. I know almost nothing about Crystal Reports, but have heard it would be the best reporting tool to pull the data from these 2 environments together. Would...
  7. danisem

    Lotus Notes and Motorola 120t cellular phone with USB data connect kit

    I am looking for a modem description file (.mdm) to use with lotus notes. I have been able to edit an existing motorola Cellect mdm file and have gotten as far as the server answering but then the connection is dropped. Any help would be appreciated. Thank you.
  8. danisem

    Watermark in Word

    I'm sorry. My first posting was wrong.[blush] I mean't clip art icon on the drawing toolbar. I did try word art at one time during the hours I have been trying to do this, but it didn't work either. So I created my picture in Paint Shop Pro and then imported the .bmp file into the clip art...
  9. danisem

    Watermark in Word

    The settings are default - 85% brightness & 15% contrast. Is there anything else to check? [bigears] Thanks
  10. danisem

    Watermark in Word

    I need help adding a watermark to word 2000 that will print on every page. I've followed the instructions found in several forums and articles, but it doesn't work. Here is what I have been doing. Pls tell me if I'm doing something wrong or if I could have some other technical problem. Open...

Part and Inventory Search

Back
Top