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 SkipVought 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: *

  • Users: rzff
  • Order by date
  1. rzff

    Select from ? code

    Hi Bob Scriver, You did it agian. It works and it is working fast. Regards RZFF
  2. rzff

    Select from ? code

    Hallo, I have one more question. Can I include the columns names 1 should be ISIN 2= Telekurs 3= Valore. Is there a way the include this in query upfront. Thanks RZFF
  3. rzff

    Select from ? code

    Hi Bob, Perfect it works fine. Thanks you very much for your help. Regards RZFF
  4. rzff

    Select from ? code

    Hallo, Is there no way that I can get this result with a query. There are a maximums of CODE_TYPE which is 1,2 or 3. Please let me know if somebody has an idea for this query thanks rzff
  5. rzff

    Select from ? code

    I hope somebody can help me with the next problem. There is one table Table: codes Artnr Code_TYPE CODE_ID 1000 1 12345 1000 2 44444 1003 2 33333 1001 1 45554 1002 1 88888 1002 2 99999 1003 2 77777 1004 2 11111 1004 3...
  6. rzff

    select from securities

    Dear Dodge, Just to let know. What I have now is the following. bookings NR ID Quantity Sec Exchange 1001 1 10000 Abc 5 1002 2 2000 def 6 1003 3 3000 ghj 7 1004 4 4000 klm 8 Names ID Type Country 1 client US 2 client US 3 client US 4 client CAD 5 exchange SP 6 exchange SP 7 exchange CAD 8...
  7. rzff

    Select from

    It works perfectly. Thank you very much for helping me. Regards rzff
  8. rzff

    Select from

    Hi Swampboogie, Thanks so much I works. Do you also know if it is possible to get only those bookings between US clients and non US exchanges? regards rzff
  9. rzff

    Select from

    Can anybody help me out with this query finaly I want to see all bookings between US clients and non US stockexchanges. But first i want to see all information in one report to be sure everything is correct. I have a tables one is named bookings NR ID Quantity SEC EXCHANGE 1001 1...
  10. rzff

    Select from ? details

    Next try :-) . I found out that if you just copy and past this table into notepad the layout stays the same with all the tabs. So here it is but now correct. ID TotalCap Accname Accnumber Period CapDetails Type 1 150000 1 1 1...
  11. rzff

    Select from ? details

    I hope this layout is more clear I dont no how else to show the table. I can use tabs. IDTotalCap Accname Accnumber Period CapDetails Type 1 150000...........................1 1.....................................1......50000...Shares...
  12. rzff

    Select from ? details

    Or even better which ID ? 1 and from periode ? 1 untill ? 1 this is maybe even easier ? regards rzff
  13. rzff

    Select from ? details

    I hope someone can help me out with the next problem . I have a two tables that looks like this. Table ID TotalCap Accname Accnumber 1 150000 1 175000 1 Brown 1 123 2 155000 2 195000 2 200000...
  14. rzff

    Select from where

    PERFECT I tried it and it worked. I will do some more testing tonight. Thanks
  15. rzff

    Select from where

    Also this result would be perfect IDCapital Accname Accnumber 1 150000 Brown 321 1 175000 Brown 321 2 155000 Yellow 8453 2 195000 Yellow 8453 Or any other result which shows the information in a more elegant way Regards RZFF
  16. rzff

    Select from where

    The tabel I am showing is just an example. This is the result when I import an XML after I imported it in excel. I would like to have a query so I can make the adjustments myself. But if you have any suggestions please let me know. I will post you the a sample spreadsheet. The imported sheet...
  17. rzff

    Select from where

    If wonder if somebody can help me with two queries if have a table named holdings. ID TotalCap Accname Accnumber 1 150000 1 175000 1 Brown 1 123 2 155000 2 195000 2 200000 2 Yellow 2...

Part and Inventory Search

Back
Top