Search results for query: *

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

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

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

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

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

Thanks a lot SantaMufasa.

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!!!

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

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

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

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

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 )

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.

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

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

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

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

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

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

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