Search results for query: *

Hello, I made a mistake in my final result. What I want to see is: Phone_number Event_Id 123 2 123 4 123 6 123 8 Thanks

Hello, I have a cursor that have the following data that I select from a table: Phone_number Event_Id 123 1 123 2 123 3 123 4 What I want to do is to increase a number in the event id every time he does...

Can I send you my excel file for you to see what's happening please? I'm sorry but I don't know much about vba. Thanks

have you tried in the report, data menu, report data options? You have a null values tab where you can choose to appear 0.

I did all that but It still doesn't work.

I'm sorry.Is that I am a little bit confused for so many changes that I've made for run this 1) the sheet that you are CHANGING a value in column G Sheet 1 named Requests 2) the sheet that your Filtered table is in Sheet 1 named Requests. In here I've created a table with columns STATUS_VALUE...

Hello, Now the macro doesn't run anymore. Not even when I run it mannualy. And when I change a value in Sheet 1 it doesn't do anything also.

Here it is: Sub STATUS_DONE() ' ' STATUS_DONE Macro ' ' Range("A1:L1").Select Range(Selection, Selection.End(xlDown)).Select Range(Selection, Selection.End(xlDown)).Select ActiveWindow.SmallScroll Down:=24 Selection.ClearContents ActiveWindow.SmallScroll Down:=-3...

Hello, I did what you said: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("G:G")) Is Nothing Then Call STATUS_DONE End If End Sub But when I change column G for one record to DONE in sheet 1 the macro doesn't run. I still don't have in sheet 2 the...

Hello, The heading of the column is "Status" and is the G column. Thanks.

Hello, I have an excel workbook with 3 sheets. In the first one, I have listed all the requests that were made to me. And one of the column of sheet 1 has the status (Made, Pending). The second have the subset of requests that are already done and the third sheet has the requests that are still...

Hello, We have DataStage 7.5.3 installed on an HP/UX machine. Our database was an oracle 9i instance. Last week we bought a new DB server. It's an Oracle RAC with 10G Version. When we were running some test we found two diferent problems: 1) Our dsx server had oracle client 9.2.2 and then...

Hi, The indexes were rebuilded after the upgrade and all the statistics that were lost, are now up to date.

I have a select query script that runs fine. I am trying to create a mview with it but when I try to create the view,it runs and runs and never creates the view; I have to cancel. I let it run for an hour without success, the actual select query takes about 5 minutes. If I use the select in a...

Hello, In 9i I had a procedure that opens a cursor with a select with union all inside. Then, the values of the cursor are inserted into a table and it gives a commit each 10000 rows. After upgrading to 10g, the procedure that used to take about 1min to run, takes over an hour. Could you...