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

  1. chakri99

    DTS and AS/400

    I don't know whether this will work. It worked for me for similar error. I used database2.filenam2.filename2 The second filename is for the member name as db2/400 would look for that file as well as member name. You may use filenam2 or even *first as the member name Give it a shot and let me...
  2. chakri99

    How to create Left outer Join while using SQL Cubes

    I do not have null values Chakra
  3. chakri99

    How to create Left outer Join while using SQL Cubes

    I tried doing Virtual Cubes but the way the data looks is quite different. The Join would correctly retrieve 90 records from Primary file as required by a left outer join. However It would show all 150 records for File2 when seen in detail instead of retrieving only 90 records. Is there any...
  4. chakri99

    How to create Left outer Join while using SQL Cubes

    Hi I have 3 files to join and get the data thru SQL Server Cubes. File1(Primary) has 90 records while File 2 has 150 records File1 and File2 can be joined by Feild1A = Field2A to get a set of 84 records when the Select condition is Feild2B = 'NDC' (one of the values for that field) I would...

Part and Inventory Search

Back
Top