Have you concidered breaking this into steps. Build temp table with ID and MAX, MIN or whatever single row COD_CHANNEL. Then insert from the temp table.
CREATE TABLE BTEMP AS
(SELECT B.ID,MAX(COD_CHANNEL)
FROM TableB B
GROUP BY B.ID);
UPDATE A SET COD_CHANNEL = (SELECT T.COD_CHANNEL FROM...
Here is the problem, I need to be able to have an Access database open a URL and Capture the HTML source as text from the Web page. I also need to search and parse the HTML. Any help would be appreciated.
I have built and used Time Dimension tables in a couple of architectures. The simplest architecture (But a lot of detailed information) stored all time values in one table and had the following fields: Four digit year (2002), Leap Year Indicator (1 = Leap Year, 0 = Not a Leap Year), Quarter...
I am looking to upgrade my current reporting system, and was wondering what people think of Crystal 9. I have heard that there is not a separate query tool?? How is custom SQL introduced??
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.