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

    Most Recent Date

    This query actually does work. The problem was performance on the actual table. Table has over 260,000 records. I re-indexed the table, Updated Statistics on the table and then added the date filter to get only records in the last 10 days. This still takes about 5 minutes to run, but it was...
  2. unique12u

    Most Recent Date

    I can make this work using a temp table as follows: SELECT fm_cost.fmc_terminal, fm_terminal.fmt_owner, fm_cost.fmc_vendor, p_altname.pn_name, Max(fm_cost.fmc_date) as max_date, fm_cost.fmc_prodlnk, inv_header.ivh_product, inv_header.ivh_desc FROM fm_cost,fm_terminal,inv_header,p_altname WHERE...
  3. unique12u

    Most Recent Date

    PHV: This query gives me every record in the table - the join is not correct somewhere.
  4. unique12u

    Most Recent Date

    I have also just tried without success: select fmc_terminal, fmc_vendor, fmc_prodlnk, fmc_date, fmc_time, fmc_cost FROM fm_cost WHERE fm_cost.fmc_date = (Select max(fmc_date) from fm_cost as f where fm_cost.fmc_terminal = f.fmc_terminal and...
  5. unique12u

    Most Recent Date

    Sorry typo - I do have it correct. Still not getting results. Any other help?
  6. unique12u

    Most Recent Date

    I have the below table and want to get the below results. I basically need a way to get only the most recent date entry from a table of prices. I have tried this: select fmc_terminal, fmc_vendor, fmc_prodlnk, fmc_date, fmc_time, fmc_cost FROM fm_cost WHERE fm_cost.fmc_date =...
  7. unique12u

    Select subquery problem URGENT Deadline to meet

    Thanks for the help - I ran UPDATE STATISTICS on the database and query runs just fine now! Thanks for all the help!
  8. unique12u

    Select subquery problem URGENT Deadline to meet

    This seems to work great, but the query is taking a LONG time to run - even with indexes on the tables. Any suggestions to speed the query up? There are 32000 records in the gl_delete table and of 300,000 in the gl_master table. Thanks Nique
  9. unique12u

    Select subquery problem URGENT Deadline to meet

    Ok I can get this select query to work select * from gl_master,gl_delete where gl_master.glm_series = gl_delete.gld_series and gl_master.glm_account = gl_delete.gld_account and gl_master.glm_prft_ctr = gl_delete.fld_prft_ctr but I cannot do the delete query that I need to do...
  10. unique12u

    Select subquery problem URGENT Deadline to meet

    I have the following two tables gl_master glm_account,glm_prft_ctr 10000 1 10000 2 10000 3 10000 4 gl_delete gld_account,gld_prft_ctr 10000 2 10000 4 I am doing the following query: SELECT * FROM gl_master WHERE glm_account in (select...
  11. unique12u

    Delete Query returning too many records

    Delete Query based on another table I am trying to run the following Delete Query DELETE Master.* FROM Master WHERE((Master.glm_account) In (SELECT glj.glm_account from glj) AND (Master.glm_prft_ctr) In (SELECT glj.glm_prft_ctr from glj)); The problem is it is trying to delete all the...
  12. unique12u

    Add and Delete Excel Columns VBScript

    How do I get it reformatted into my correct format? mm/dd/yyyy hh:mm:ss If I do the concatenation you suggest it will be m/d/yy hh:mm
  13. unique12u

    Add and Delete Excel Columns VBScript

    I have an excel sheet where column C is a date, Column D is a time and Column E is blank. Number of rows can vary. I need code to tell it to add column C and D together into column E and then format column E as mm/dd/yyyy hh:mm:ss and then delete column C and D. Any help out there? Thanks Nique
  14. unique12u

    Procomm Dial up to SCO

    We are using Procomm 4.8 to connect to SCO. The program and settings work FINE on WIn98 but the modem will ot negotiate and connect with the same software on Win2K. What should be fixed or changed on the WIn 2K to make this work? Thanks

Part and Inventory Search

Back
Top