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!

  • 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. gtb12314

    Help with Summary field in Report Footer

    Hello All, I have a crystal report which consists of total 8 pages. And on page 9 I want to show only the grand total without displaying anyother information. So my report will have 9 pages all together. When I am adding a summary field (distinct count) in the Report Footer its getting...
  2. gtb12314

    Requirements of SQL Server 2005 Stored Procedures for Crystal Report

    Hi All, I want to learn how to create crystal report off of SQL Server 2005 Stored Procedure. So anybody please let me know from where I can download the documentation on "Requirements of SQL Server 2005 Stored Procedures for crystal report. I am using Crystal Report XI. Any help is greatly...
  3. gtb12314

    Requirements of SQL Server 2005 Stored Procedures for Crystal Report

    Hi All, I want to learn how to create crystal report off of SQL Server 2005 Stored Procedure. So anybody please let me know from where I can download the documentation on "Requirements of SQL Server 2005 Stored Procedures for crystal report. I am using Crystal Report XI. Any help is...
  4. gtb12314

    Help With Executing Stored Procedure

    Hello Everyone, Below is my package & procedure and the code to execute the procedure from SQL*PLUS. (I) create or replace package mypackage2 as type myrecord is record (myempno emp.empno%type, myename emp.ename%type, myjob emp.job%type, mydeptno dept.deptno%type, mydname...
  5. gtb12314

    Determine the difference in days between two dates ?

    Hi Everyone, How to determine the date difference between the current record and the next record? For example, for every employee in DEPTNO 10, I want to determine the number of days between the day they were hired and the day the next employee was hired. Below is a sample of...
  6. gtb12314

    ORACLE WITH CLAUSE HELP

    Thanks a lot SantaMufasa.
  7. gtb12314

    ORACLE WITH CLAUSE HELP

    Hi Guys, I want to learn about "Oracle WITH Clause" from scratch. Please anybody let me know where can I find good notes or documentation along with several good examples. Any help is greatly appreciated. Thanks!!!
  8. gtb12314

    Pls Help with Date format picture ends.....error

    Hi Everyone, I am getting the following error when I run my crystal report. Failed to retrieve data from the database. Details: HY000:[DataDirect][ODBC Oracle driver][Oracle]ORA-01830: date format picture ends before converting entire input string [Database Vendor Code: 1830] I am using...
  9. gtb12314

    Pls Help with Date format picture ends.....error

    Hi Everyone, I am getting the following error when I run my crystal report. Failed to retrieve data from the database. Details: HY000:[DataDirect][ODBC Oracle driver][Oracle]ORA-01830: date format picture ends before converting entire input string [Database Vendor Code: 1830] I am...
  10. gtb12314

    DataType conversion help

    I tried both the below solutions but still I am getting the time along with date. CONVERT(DATETIME, receivedate, 112) CONVERT(DATETIME, receivedate, 101
  11. gtb12314

    DataType conversion help

    I cannot convert just to date instead of datetime. e.g. CONVERT ( date , receiveddate, 101 )
  12. gtb12314

    DataType conversion help

    my field name is receiveddate and its datatype is varchar2(10) and its value is 2008-08-01. So can I do like this as below: CONVERT ( date , receiveddate )
  13. gtb12314

    DataType conversion help

    I am sorry my varchar2 field has only date in it. And it's stored as 2008-08-01. I want to convert this into date datatype. please help me out.
  14. gtb12314

    DataType conversion help

    Hi All, I am using SQL SERVER 2005 and one of my table has varchar2 field whose value is date & time. I want to know how to convert varchar2 field into just date datatype. Any help is greatly appreciated. Thanks in advance
  15. gtb12314

    Help with Grouping

    Hello Everyone, I have a group based on table.desc with customized group name as follows: if table.desc = "" then "...." else REPLACE({table.desc},"Total ","") Whenever there is no data for table.desc="Unrealized Gain/Loss"(I mean if the entire row is 0) then I am suppressing the Group...
  16. gtb12314

    SQL Help,,,please

    Below is the output from my sql command. Now I want to see whether these employees have multiple Employee group(talbe.employee_group) or not. EMPLOYEE R_PLAN TOTALPTOPLANS 3461852 PTO 2 3399292 PTO 2 390765 PTO 2 165076 PTO 2 87270 PTO 2 492298 PTO 2 253948 PTO 2 112060 PTO 2...
  17. gtb12314

    SQL Help,,,please

    my question is I want to find out the employees who has more than one PTO plan and more than one employee group(table.employee_group) So I think my query is bringing employees with multiple PTO plans but not with multiple employee groups.How to write a query for this. Also I want to make sure...
  18. gtb12314

    SQL Help,,,please

    I am sorry, here is my code: select employee,r_plan,count(*) as TotalPTOPlans from lawson.taeemaster where r_plan='PTO' group by employee,r_plan having count(*)>1
  19. gtb12314

    SQL Help,,,please

    Hi All, I want to write a query to find out which employees have multiple PTO plans and also who has multiple employee groups (database.employee_group) I am writing a query against one table which has field (database.plan) for plan names and (database.employee_group )for employee...
  20. gtb12314

    Help With Creating View

    Hi All, I have a sql command with temporary tables, but whenever I am trying to create a view with temporary tables I am getting an error as below: "Views or functions are not allowed on temporary tables. Table names that begin with ‘#’ denote temporary tables." Please anybody let...

Part and Inventory Search

Back
Top