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...
1. Yes, the other entries show up on the screen when i look at the calendar.
2. I'm using day/week/month view.
3. not using any categories.
do you have any idea what's happening? it's driving me crazy!
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...
1. the file is continously updated.
2. when I says "hundreds Sql" I mean each doing something like this:
select * from x,y where x.field1 = y.field1 and y.field2 in('01' '03') order by....
The point is that the "flat" file contains a lot of data very usefull to select records and I
don't want...
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...
Sorry here is the code:
I
have a table entity_platforms defined as
create table lg/entity_platforms
(
abbreviation for column abbr char(5) not null with default,
platform varchar(100) not null with default...
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.
How it went? It went well, but there were no questions like was posted here, but that is OK.
They have one more person to see but the feedback was they 'liked me'. I need them to 'love me'. It is very much like a marriage this interviewing thing.
Wish me luck, my suffering, my Last Record...
Always comes up zero. I made a new column, entered 4 lines of values and that one worked fine. But not the original one. It did come from another computer system originally but why should that matter?
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
Yep but give a zero
V LA05332 ALB MN NYLN POP OVER JK 8/14/05 18
V LA62972 ALB MN PGSP ZIP FRT JK 8/08/05 24
V LA71582 ALB MN PVNC VARSITY JK 9/08/05 48
V LA74482 ALB MN PVNC RAINWEAR 7/19/05 122
V LA81422 ALB MN WOOL VARSITY JK 10/01/05 24
V...
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.