Search results for query: *

Hello experts, Need help figuring out YeartoDate and Last12Months syntax. I'm trying experts, trying my best. YearToDate = is it select * from table where convert_to_epoch(arrival_time) between TRUNC(SYSDATE,'YEAR') and sysdate; Last12Months select * from table where...

Oh experts, I am finally on my way with Oracle. I've tossed everything I know about SQL Server and strictly focusing on Oracle. So I need help with the following. I have created a package with a procedure and I need to know how to find all data for the prior week starting from Sunday to...

Hello experts, I have sent an email to the Oracle 9i forum and received an answer saying that the issue might be related to crystal reports so I need all the experts advice. I have created a very simple Oracle Stored procedure(I am trying to learn oracle 9.2) and what I found was that crystal...

Hello again, I was wondering if someone could help me out with my learning. I am trying to totally disregard any understanding of SQL Server and start fresh with Oracle. I have created a stored procedure/package combo using oracle 9.2 as follows. Now could someone please explain the line...

Hello, Me again. Is there any way someone can help me make a conversion of a sql server user defined function to Oracle 9.2.function. Again I am still learning oracle but if done, this would really help me to see the basis of an oracle template and how one does things. I was wondering if I...

Hello, I am extremely puzzled. I am using SQLDeveloper and trying to create a stored procedure on oracle database. I have a sql server backround but not much in oracle. I've been told that it is relatively the same but I am not finding that. I will be connecting the stored procedure(oracle...

Hello, Still loving this web page:) I am using crystal report 9.2.2.634 Full version and was wondering if someone could tell me how to just chart on the last 12 months. I have not taken advantage of learning indepth the charting feature of crystal. I have created a group based off...

Hello, I was wondering if someone could recommend or help me on this. The company I work for is using an application with the back end on Oracle 9. I am not familiar with oracle at all and I am more comfortable using Microsoft SQL Server. Now If I had the data I needed from the Oracle...

Hello, I am having a brainfreeze today. Could someone please help me figure this out. I have a simple report as follows GH1 OpenTickets 141 RT Formula 141 GH1 Resolved Not SRF 43 RT Formula-184 GH1 SRF Older 30 days 6 RT Formula-190 GH1 SRF...

Please is there anybody who can help. I have two servers. Server x running SQL Server 7.00.1063 and server y running sql server 2000 sp 3(or ver 8.00.760 sp3. Operating system for SQL server 7.00 is Windows NT and for SQL Server 2000 it's Windows 2000. Now when I run under query analyer on...

Hello, I have just purchased a new 3 ghz p.c Motherboard is ASUS p4p800-e. My question is this. For some reason when I start the p.c it sometimes hangs. What I mean by this is it takes about 5 minutes after I start my p.c for the computer to show the motherboard information. So I have to...

Hello, I have upgraded an old p.c to 800 mhz Intel pentium III with 524 megs of Ram. Please correct me if I'm wrong but I think my p.c. should run fairly quickly. Well the problem is after I reformatted my two hard drives(20 gigs) each and fresh install of windows xp pro, my system is much...

Hello everyone, Nobody can seem to figure this problem out. To explain, we have server opearting with windows server 2003 and iis6.0. For some reason, without any noticeable pattern, users occasionally get a Service Unavailable error and cannot view not only the desired web application, but...

Does anybody know how to copy all DSN's from one server to another. Going from Windows NT Server to Windows 2003 server. Thanks.

Hello again, I am stuck at doing some passing of data. I have a form that has 3 cascading dynamically populated list boxes. The problem is that when I click on the first list box, I want the values selected to be passed into another page. I have created a javascript functions to hold these...

Hi everyone, I have included the code for a script that I downloaded and now I need to customize it. What I need to do is in the time field at the bottom of this popup calendar, if the user types a single digit for the hour, it should populate my input box. Right now the user has to type a 02...

Hi Guys, I have a stored proc that returns data on the fly. What I mean by this is if I run the proc it returns a listing of categories. If I run the proc with a category it returns a listing of types and if I run the prco with a category and type it returns and listing of items. Now my asp...

Hello, Could someone please help me. Using crystal reports 9.2.3.970. CR Developer Full. I have created a report and placed on our intranet. When the user runs the report, the report comes back with the first page being a grey screen. However, if the user clicks the arrow key to advance to...

I need some help if possible. I have four different dts packages that are very close in naming ie SA_Update_Client01 SA_Update_Client02 SA_Update_Client03 SA_Update_Client04 and I have SQL Agent job that invokes one of these DTS but when I attempted to troubleshoot I don't know which DTS...

Hello, I am currenty using crystal 9 advanced developer edition and have a report with 3 groups. One of the groups is department and the details are in the details sections. Nowe what I need is to display one department with it's details on the top of the page on each page and for every other...