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 derfloh 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: je27
  • Order by date
  1. je27

    finding last record of each

    Hi George, I believe I figured out the syntax error in the code. I took out the AS from: ) As A and it seemed to have worked fine. I also was able to put in my where clauses. Now if you could go through a quick explanation that would be wonderful. THanks again!
  2. je27

    finding last record of each

    Hi mercury, i tried your code as well and if i change it a bit to give me other information it will return all the max timestamps of each different transaction for that user. So what I'm trying to get it to do now is return the last transaction for that user. ? hope that makes sense. Thank you !
  3. je27

    finding last record of each

    Hi George, I've tried to run the code you supplied and its giving me the following error: ORA-0095 Missing keyword on the line containing: ) As A Also, is Inner Join a recognized sql function, because it seems only the Join is blue and the Inner isn't. could i add another where clause...
  4. je27

    finding last record of each

    I have a table that contains a timestamp that is captured after each time a particular unique instance (example person) is changed or a transaction takes place on that person. So for example if my table contains 30 different users that are logged in or logged out or absent or on vacation i want...
  5. je27

    formatting data in sql

    I wouldn't know where to put that select statement or how to create the function from just one table? Sorry if I'm unclear. Thanks, JE
  6. je27

    formatting data in sql

    Well the table that has the codes doesn't have all the other columns. This is my sql: SELECT lot_warehouse.molname as Compound_Name,lot_warehouse.lnb_ref as LNB_Ref,sts_project.project_code as P_Codes...
  7. je27

    formatting data in sql

    So my next question for you is how? :( I have a very large sql statement that is returning many more columns than those 4. I know that I would have to change the function a bit to include those columns but I'm stuck on what I would change "je27" to. For instance in the function: for c in...
  8. je27

    formatting data in sql

    Sorry, for the misunderstanding. Ideally I would like to be able to run a sql to output the data the way you have shown. I just wasn't sure how the function worked, but you have clarified that now. I simply have to run the create function sql then incorporate: col code format a20 select...
  9. je27

    formatting data in sql

    OH and Thank you!!!
  10. je27

    formatting data in sql

    Hi, So this function is used after the data is retrieved, right? So if i have an application I can use a function like this to manipulate the data and output it this way in excel?
  11. je27

    formatting data in sql

    Ok thanks, will do.
  12. je27

    formatting data in sql

    I have a query that is looking in many different tables and I am trying to see if there is a way to retrieve the data below so that it removes duplicates but puts the values that are not dupilicate in the same cell with a comma delimiter. Tables: Name.......Code....Well....Project...
  13. je27

    formatting data in sql

    This is a relational oracle database.
  14. je27

    formatting data in sql

    I have a query that is looking in many different tables and I am trying to see if there is a way to retrieve the data below so that it removes duplicates but puts the values that are not dupilicate in the same cell with a comma delimiter. Tables: Name.......Code....Well....Project...
  15. je27

    converting lotus 123 macros to excel 2000

    I am trying to convert a lotus 123 workbook or spreadsheet into an Excel Workbook and I had 14 cells that could not be read. I figured out the formulas for these cells in Lotus 123 but I do not know how to convert them so that Excel can read them. The other problem is I do not know how to...

Part and Inventory Search

Back
Top