Search results for query: *

I know the answer to this question has been posted, but I cant find it. I have summed hours worked as a string in Crystal like 423:22 [hh.mm]. I would like to convert the string to a number to return sum values on the various groups of codes within the report. See sample below. I would like to...

Hi I am trying to derive the correct absence startTime of all exceptions (absence codes)from the following SQL statement. But, I am getting the following results with all start times beginning at 00:00 and ending 02:00X. With the following SQL statement, how can retrieve the correct...

Hi, I am baffled by this error. I can run the statement below in SQLPLUS, Toad, and SQL Developer. However, when I try to execute it as job in Oracle 9i, the error below is returned. I know it is a simple fix, but I have been unsuccessful in finding the solution. Thanks set pagesize 0; set...

Hi I am using Oracle 9i and Oracle's job scheduler to export data at specific intervals. I would like to add the date and timestamp to the file name for each file. I have been successful adding the date within the export, but not to the name. Here is what I have at this time. Thank you set...

Hello, I have two tables employee and cognosEmpData. I need to match the SSN in both tables and update the personelID column in the employee table if there are matching SSNs. For the remaining non matches,I would like to update the complete record record set from cognosEmpData to employee. Here...

Hello I have the query below in SQL Server 2005 UPDATE InMwhBad INNER JOIN InMwhGood ON InMwhBad.[Item #] = InMwhGood.[Item #] SET InMwhBad.[Bin Location] = [InMwhGood].[Bin Location] WHERE (("where warehouse"="RA")); I am trying update the records in the InMwhBad table with the records in the...

Hi, I am using a password protected Adobe PDF form which opens within the infoview portal. When I click on the form name to open it, InfoView assigns the form the name of 'object_view.aspx'. When I email the pdf form by clicking an email button on the form, InfoView change the form name to...

gm I have the following statement which is converting a problem code {number) to a modified code consisting of a character and a number. I would like the original problem code {INCIDENT.PROBLEM_CODE} number to display if the code is not within specified else if statement. I am getting the name...

Hello, I have a project requiring a unique sequential number for the month. We are trying to generate accident control numbers for two facilites. For example, the first digit indicates the facility. It will always be "C" or "R". The next six digits will be the accident date not the system date...

Hello, a co-worker sent this script to me asking for help. I am unable to assist. Can someone decipher the problem with this script? DECLARE @out AS int, @in AS int, @transnum AS int SET @out = 1 SET @in = 1 SET @transnum = 1 BEGIN WHILE @out < 801 BEGIN...

Hello all, I have created five separate reports, but I am trying to enhance my reporting skills by moving from selection experts to formula variables. With variables, I can show all of the data in one report. I have a table with the following fields complaint, compliment, operator, date_recd...

I have two tables linked on SSN. In the "FirstNoticeInjury" table, there are records which do not reside in the "SupvrRprt". How do I query for all of the records which are equal in both tables and the records not in the "SupvrRprt" table? SELECT "FirstNoticeInjury"."SSN", "SupvrRprt"."SSN"...

I am trying to compare a sikbal table and a sikconv table. The fields in the sikbal table are LName, FName, Department, & SikBalance. The fields in the sikConversion table are LName, FName, Department, & SikConverted. If the LName & Fname are listed in the sikbal table, the person is eligible...

Hi, I am working with a large SQl server 2000 database which has lots of tables. Is there an SQL statement which will return all the tables with a specific column(field) name? For example, show all tables with the field name call_time. Thanks

Hi, I am developing a report with the fields: Resource.resourceFirstname -->Agents Name AgentConnectionDetail.startDateTime AgentConnectionDetail.endDateTime I have inserted a group on AgentConnectionDetail.startDateTime and selected "The section will be printed: for each hour which is...

Hi, I have a report with a field name "date". I have created a parameter field with a date range option and I can not figure out how to show the parameter in the report. For example, I have the text Start Date: End Date: When the date range is selected, I would like to show the selected...

I am having a hard time with a subform updating the SSN field from the main form which is a continous form. The main form has information about all employees. The subform house all of the required examinations of all employees. The two tables are DBO_employee and Exam_Histry. The relation ship...

Hello, I have generated a report and added a text object to the PH display to the users( No Records Found For This Date)when no records are found. Currently, only a blank page is shown when no records are found. Obvisously, the users think there is something wrong. I placed this code in the...

Hi, how do I populate a check box with a check mark(field=scheduled)if a date field (next_biennial) is populated with a date? Thanks

Hello, I as using a sub-form to capture historical data. There are five fields I am dealing with Last_Biennial, Next_Biennial, Recertification, Re-Eval, and Letter_Sent. If the Next_Biennial field is populated with a date, then I would like for the fields Recertification and Re-Eval to be hidden...