Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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