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