Search results

Dear All, I need some help with my SQL query... I am trying to build a SQL query with which I can calculate the so-called Average True Range (ATR) (-> http://stockcharts.com/help/doku.php?id=chart_school:technical_indicators:average_true_range_a). I have a table which contains stock prices...

Dear All, I am not the SQL expert and I would be very happy if someone could help me with the following question: The first query gives me the closing price of the last trading day (here just 11/28/08): SELECT Ticker, Close FROM Data WHERE dDate=#11/28/2008# GROUP BY Ticker, dDate, Close...

Hi there, the following query retrieves the Top 20 values of "Mcap": SELECT TOP 20 D.Mcap FROM Data as D WHERE ... ORDER BY Mcap DESC How do I have to modify the code so that I get the sum of the Top 20 values of Mcap? Thank you for your help... Diana

Hi, is there any alternative of the DatDiff function, which counts only working days between two given dates? Regards, Diana

Dear All, I have the following problem and I would be happy if somebody could help me with that: So far I had two tables. One contained customer orders, the other a description of each article. The connection between both tables was through a unique article name, which was the primary key of...

Hello, I have one question regarding the use of an INSERT INTO query. I tried the following code, which I found on http://www.techonthenet.com/sql/insert.php, however unfortunately it does not work. The text on the website says: “The use of the dual table allows you to enter your values in a...

Dear Forum, please let me ask a second question. I have two tables tbX and tbY, which both contain a column called "LastName". What I am looking for is a query or macro, which compares the columns "LastName" of tbX and tbY and then tells me, which items are contained in tbX but not in tbY. To...

Dear Forum, I have a question and I would be very happy if you could help me with some thoughts on how to start. I have a database, which contains one table tbX, which ist interesting in this context. tbX needs to be updated on a regular basis, hence it would be very helpful to automate this...