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 Mike Lewis 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. harfri

    Who can help me with a report in SQL

    I have 2 tables and I want to have a report which shows the value in another currency. Table A (exchange rates) Date Rate Currency 1-1 1.11 USD 2-1 1.12 USD 3-1 1.13 USD...
  2. harfri

    Insert data from Table A into Table B how can I do that?

    I have table A with my account balance and i would like to use this data to insert them into my new table B. In this table I would like to see my account balance per day. Is this possible with Oracle sql? Is there a insert statement or a function which i can use? I would be very happy if...
  3. harfri

    Insert into a new table

    Who can help me out? I have a table with a balance in USD with 2 records Table 1 Date. Balance 1-Jan-2018 100 USD 5-Jan-2018 200 USD I would like to know how i can create a new table based on Table 1 The new table should have the following records Date. Balance 1-Jan-2018...
  4. harfri

    Select From....Security ID

    Hi PHV, Sorry that I have confused you. For me it was not so clear where to post my question. If have run your query but I without result. Is it because of a SQL Dialect? regards
  5. harfri

    Select From...SecID

    Hi, Thank you for this query. I have try to run this in MS-Access. But then I get a syntax error. Any Idea? regards
  6. harfri

    Select From...SecID

    When using MS-Acces this works fine: SELECT [Tabel A].SECID, [Tabel A].SECSYMBOL, Count([Tabel A_1].SECID) AS ColNum FROM [Tabel A] INNER JOIN [Tabel A] AS [Tabel A_1] ON [Tabel A].SECID = [Tabel A_1].SECID WHERE ((([Tabel A_1].SECSYMBOL)<=[Tabel A]![SECSYMBOL])) GROUP BY [Tabel A].SECID...
  7. harfri

    Select From...SecID

    Can anyone help me with this SQL Query? I have two tabels TABEL A SECID SECSYMBOL US00111 AAA US00222 BBB US00333 CCC US00333 DDD US00333 EEE US00333 FFF TABEL B SECSYMBOL SECNUM AAA 1234 BBB 1235 CCC 1236 DDD 1237 EEE...
  8. harfri

    Select From....Security ID

    Hi dhookom, Thank you for your help. I will and have posted my question on some other forum also. Thanks so far
  9. harfri

    Select From....Security ID

    Hi Dhookom, After some try and error from my side it works perfectly SECID SEC(1) SEC(2) SEC(3) SEC(4) US00111 1234 US00222 1235 US00333 1236 1237 1238 1239 But what if I would like to convert this into PLSQL? Will this query work?
  10. harfri

    Select From....Security ID

    I have to tabels in MS SECID SECSYMBOL US00111 AAA US00222 BBB US00333 CCC US00333 DDD US00333 EEE US00333 FFF SECSYMBOL SECNUM AAA 1234 BBB 1235 CCC 1236 DDD 1237 EEE 1238 FFF 1239 GGG 1240
  11. harfri

    Select From....Security ID

    This is what i have know: SECID SECSYMBOL ColNum US00111 AAA 1 US00222 BBB 1 US00333 CCC 1 US00333 DDD 2 US00333 EEE 3 US00333 FFF 4
  12. harfri

    Select From....Security ID

    The first part works I have copy and paste your query. But I do not know how I have to run the second part.... Regards Harrie
  13. harfri

    Select From....Security ID

    Hi, The first step works fine :-) But i do not understand how to run the second step. Is it possible to do this in 1 query? Many thanks for your help.
  14. harfri

    Select From....Security ID

    Can someone help me with this query plz
  15. harfri

    Select From....Security ID

    Can you give me a hand...Or is it really difficult for an expert. thanks in advance Maybe Swampboogie knows how to solve this :-)
  16. harfri

    Select From....Security ID

    I would rather use SQL instead. Do you know how this can be done? thanks in advance
  17. harfri

    Select From....Security ID

    Can anyone help me with this SQL Query? I have two tabels TABEL A SECID SECSYMBOL US00111 AAA US00222 BBB US00333 CCC US00333 DDD US00333 EEE US00333 FFF TABEL B SECSYMBOL SECNUM AAA 1234 BBB 1235 CCC 1236 DDD 1237 EEE...

Part and Inventory Search

Back
Top