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: LaurenM
  • Content: Threads
  • Order by date
  1. LaurenM

    Selecting from all elements in a list

    I am trying to find all users who had transactions on three different dates and I don't want to wade through a compilation of the transactions of those dates. The only way I know how to do it is with intersect: select * from transactions where transaction date = date1 intersect select * from...
  2. LaurenM

    select top 4 values from columns

    Hi Everyone, I have a table with the following structure EmployeeID Number Year1 Date Salary1 Number Year2 Date Salary2 Number Year3 Date Salary3 Number Year4 Date Salary4 Number Year5 Date Salary5...
  3. LaurenM

    1722 error

    Hi Group, I have this payroll table that I am just wanting to get the total number of records from, which is done using select count(*) from payroll, now I need to format the number so it is easier to read the number, the table has several million records in it. I have tried using to_number...
  4. LaurenM

    A Permissions Question

    This is just a hypothetic question for right now. Supose a user/schema is granted select permission to use a function, call it function1, in the DB, and suppose function1 calls other functions. Now, does the select permission of the user/schema cascade down so that the user/schema can now call...
  5. LaurenM

    ORA-06502 PL/SQL: numeric or value error

    Hi Everyone, I have this function I am building so I can parse long datatypes. I keep getting a ORA-06502 error when I come to the following line select rls.text into rsqlcode from report_level_sql rls where rls.id = r_id; rls.text is the column with the long datatype, rsqlcode is declared...
  6. LaurenM

    Transposing data

    Hi everyone, I'm trying to get some data displayed, but I want it transposed, and I can't figure it out, and the examples that I have found on the 'net haven't addressed my issue. What I have is a list of contacts and what company they are with, so a straight up select query will give me that...
  7. LaurenM

    Working with nothing (not null)

    Hey All, I'm working on report for the company website reporting various stats, what reports where run, where people when, etc. This report, the user selects a month and enters a year, and the various stats for the month selected and the month previous are populated into the report. Fairly...
  8. LaurenM

    Set Operations vs Subqueries

    I'm running a bunch of queries comparing data in two different tables, the my usual way of doing it is to use subqueries, select waht I need from each table and compare those results, however these tables are very large, 30,000 records each, so they take a long time to return results. I have...
  9. LaurenM

    form-sql element

    I use the form-sql element to guide my sql code based on user input. The two tags below are basically how I use the element. <form-sql name="monthid" value="600"> <form-sql name="monthid" value="not(600)"> Now, what I want to know is if I can use an OR in the value attribute instead of...
    • LaurenM
    • Thread
    • Replies: 6
    • Forum: XML
  10. LaurenM

    Casting

    Hey All, I'm currently converting some old Access '97 apps for use in our Oracle Database and I have a question. Once a month we get text file of payroll data. The file is not delimited in any fashion except in the sense that each line is a fixed length string, with various character positions...
  11. LaurenM

    Forcing Page Breaks on detection of XML data change.

    Hi All, I work for a multi-employer pension plan. Every month we mail out reports that we generate using XML, XSLT, and SQL. For each employer we have to run the SQL script restricting it to just that employer. Which of course means that we have to run the reports many, many times, is there a...
    • LaurenM
    • Thread
    • Replies: 4
    • Forum: XML
  12. LaurenM

    Playing with Dates

    Hey All, I work for a pension plan, and we need to know when certain dates occur for our members, such as 65th birthday for example. However when I do my calculations and then cast the result to a date using the to_date function I get a weird result I get the correct day and month, but the year...
  13. LaurenM

    MASS INSERT INTO

    I have a table that I'm trying to do a mass insert into, but one of the fields that comprises the primary key is also a foreign key, which is also a sequential number that is generated by the other table, doesn't get updated after the first record is inserted. Is there any way to keep...
  14. LaurenM

    XSLT page breaks

    Hey All, I hope that I have the right forum, right now my boss has me converting a bunch SQL queries into pdf reports using XSLT. Which is fine and has been going well. I've been asked to add another tweak to one of the reports. One of the reports lists the results by department. My boss now...
    • LaurenM
    • Thread
    • Replies: 1
    • Forum: XML
  15. LaurenM

    XSLT or SQL

    Hey All, I hope that I have the right forum, right now my boss has me converting a bunch SQL queries into pdf reports using XSLT. Which is fine and has been going well. I've been asked to add another tweak to one of the reports. One of the reports lists the results by department. My boss now...
    • LaurenM
    • Thread
    • Replies: 0
    • Forum: XML
  16. LaurenM

    Fun with dates

    Is there any way that I can do comparisons with just a year? What I am working on is a user enters a four digit year, i.e. 2006, now is there anyway I can do any date manipulation from that, specifically put 31/12/ in front of that? B/c if I can then all other date functions are possible. I...
  17. LaurenM

    WHERE OR NOT WHERE THAT IS THE QUESTION

    Hey all, I need some help with figuring out the logic of the where stmt. Here's the situation: I have a web page front end, where the user inputs a criteria. If they want all pieces of type 3421, then they input 3421, and all pieces of type 3421 are displayed. Thats the easy part. However...
  18. LaurenM

    ORA-00904 ERROR

    I need some clarification on the ORA-00904 error documentation. I have a column that is a case stmt, and I'm trying to use that column in the WHERE clause of my sql. Code: SELECT . . . CASE WHEN YTD < YMPE THEN 100 WHEN YTD > YMPE THEN 200 ELSE 0 END AS...
  19. LaurenM

    comparing previous record with current record of a query

    I'm trying to create a query that will show me when there is a difference of say 10% (the absolute amount really doesn't matter) between the previous record and the current record in a table. Example: Name |Score John |80 John |85 John |100 The query should show me the records...

Part and Inventory Search

Back
Top