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...
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...
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...
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...
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...
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.
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.