Search results for query: *

I need some serious sql help. I have a program that goes through our line item sales data and produces a report on a customer by customer basis detailing the summary data for the line items, IE: total sales, total cost, margins, etc. However, in meeting with the sales staff last week, they...

Hello - only my "recurrences" entries are printing from my calendar. none of my other entries are. Not sure how to resolve. Thanks, Pete

I have a customer master file (CM) that contains a subset of records I culled from the production file. I would now like to copy every detail record from a production order file to a duplicate test file for which the customer number exists in CM. Here is what I've attempted so far. Actually...

I face this strange problem when I run this query in STRSQL. SELECT * from kldadbfi3/norio10l WHERE PIPPO = '220215' This query takes 10 seconds to return the results (just 1 record which satisfies ) Where as the query SELECT * FROM...

I need to read a "flat" file with (hundreds) of sql. The file is very simple: A status field A record type field A key field A data field I'd like to define a view for each type of DS so I can use them freely via Sql without having to hardcode positional substring in the statements...

I'm trying to create a relationship between foreign key entity_platform_categories.platform_abbreviation (char 5) to reference the base file entity_platforms.abbreviation (char 5). The entity_platform_categories.abbreviation column (char 10) is not defined in the relationship.

I am trying to upgrade a PC at IE 5, to IE 6. But every place I see the download for XP, while the user is on Win 2000.

HI I have a user who has the Outlook Exress as the default so that when she wants to send an email off of the WORD document for example, it can't be done. I wanted to know how to change this situation for her. THanks, Pete

HI I need to provide totals based on the color column: THe color column is ALB, ANA, ARK. When there is a 'break' a new color I want to include a total line of the previous color. LA64592 ALB MN PGSP VARSITY JK 8/09/04* 18 3 LA74482 ALB MN PVNC RAINWEAR 7/09/04 356 356 LA78532 ALB MN...

Looking for any experience w/ API's. How and which ones do you typically use. THanks, Pete

I was reading an RPG 400 book. they talked about pointers in the RPG program. I have never seen any code using this. How is it used?

Please help have an interview tom. haven't had time to study.

How do you setup Exmerge? (for archived emails). Thanks, Pete

HI Does anyone know where FAVORITES are stored, on the local hard drive? Thanks, Pete

Do you know how to write a delete statement to delete by a composite key/ I can do it by one, but 3 doesn't seem to work

Hello - I am very new to VBA and Excel programming. I havew some data that the user would like to sort by color. I need to keep only those real data rows. Here is the data: Where you have the V/ that is the first row I want as well as the rows that follow. I guess you could stop at the total...

When you group based on one or more fields, there will be other fields that aren't part of the grouping and you have to instruct the query what to do about it. In other words, anytime you use GROUP BY, any fields not listed in this list have to have some kind of modifier in front of them, like...

We have a few remote offices. They cannot access outlook in a normal fashion partly bec. they go through another company's network. So we use Webmail. First of all is there a better way, and in using webmail, what happens is often attachments do not open, and some emails do not display. Any...

Hello, I always send a weekly email to the network admin, asking which tape set he needs for the weekly backup. He replies back, set #1 etc... Can I have this email sent to him automatically on Thursday morning? THanks, Pete

We are reevaluating our reporting solution. Right now we use a product called CorVu to pull the data back out of our database and write reports, but it leaves something to be desired. We are going to be evaluating crystal reports, Microsoft reporting services, and possibly other products. What...