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!

  • Congratulations IamaSherpa 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: *

  • Users: PeteAmsterdam
  • Order by date
  1. PeteAmsterdam

    SQL Help needed

    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...
  2. PeteAmsterdam

    need Outlook help

    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!
  3. PeteAmsterdam

    need Outlook help

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

    Learning new SQL Tricks

    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...
  5. PeteAmsterdam

    Problem w/ SQL Performance

    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...
  6. PeteAmsterdam

    Create view

    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...
  7. PeteAmsterdam

    Create view

    Rob, 3 2 1 Yes Data Set, sorry, rows of data, flat file and then query Thanks, Pete
  8. PeteAmsterdam

    Create view

    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...
  9. PeteAmsterdam

    SQL Foreign key question

    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...
  10. PeteAmsterdam

    SQL Foreign key question

    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.
  11. PeteAmsterdam

    Typical RPG Interview questions?

    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...
  12. PeteAmsterdam

    Outlook Express is the Default

    Yes I changed that but is still happens.
  13. PeteAmsterdam

    Outlook Express is the Default

    It was but the problem remains ( i changed it to OUTLOOK ther ein the IE Tools) Would a reboot have helped or is there some thing else?)
  14. PeteAmsterdam

    having trouble download 6.0

    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.
  15. PeteAmsterdam

    Need help totaling

    Is it possible that the problem is that I have headings in that column as well and they get in the way?
  16. PeteAmsterdam

    Need help totaling

    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?
  17. PeteAmsterdam

    Outlook Express is the Default

    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
  18. PeteAmsterdam

    Need help totaling

    Its defined NUMBER w/ no decimals.
  19. PeteAmsterdam

    Need help totaling

    For the Grand total for example it creates this formula =SUBTOTAL(9,F6:F1367) why does this produce a zero?
  20. PeteAmsterdam

    Need help totaling

    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...

Part and Inventory Search

Back
Top