Recent content by iamtrying

Thanks guys, the report is calculating properly with the code provided by pmax9999.

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

Chris, I spoke with the vendor and I was advised my query is correct. The times returned is a direct result of the default values for these absences and exceptions. Thank you for your time.

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

The database was designed by a vendor and the application is supported by the same. They are fully aware of the issues associated with the DB design and they write the majority of the SQL statements for development. I have been living with this monster for awhile. Again thanks.

Okay, I removed the alter session statement and the job processed correctly. Thank you

Mufasa, The database was designed some 13 years ago and the double quotes are required for case sensitivity. What are your recommendations besides redsigning the database?

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

Thank you LKBrwnDBA, you made it look so easy. It's exactly what I needed.

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

The query ran but the results were not what I expected. The updates did not come from the RA warehouse from the "InMwhGood" to the "InMwhBad" they came from "CO" warehouse. How can that be?

Here is the outcome UPDATE InMwhBad SET InMwhBad.[Bin Location]=[InMwhGood].[Bin Location] From InMwhBad INNER JOIN InMwhGood ON InMwhBad.[Item #]=InMwhGood.[Item #] WHERE 'InMwhBad.Warehouse'='RA' (0 rows) affected

Yes it is Access code and I get an Invlaid Obect Name "InMwhBad" is SQL server. How can I make this work in SQL Server 2005

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