Search results for query: *

You are correct, my original question only involved querying one id_number. Where the aggregate of a number of runs for that id_number would result, and I'd only be interested in the highest AREASUM. But I really wanted to apply that query to a group of Id_numbers where id_number = v_id. And...

Yes Thanks! - The Select * from (...... option worked best for when I had just one id_number. But what if I have a whole set of ID numbers coming from the same table (where id_number whould be constantly changing)? Right now I have a cursor set up, but I'm experiencing problems. Perhaps a...

T - Thanks! That did the trick!

Hello All, I have a query aggregating a result set and grouping by 3 particular identifiers. I'm only interested in the first result where the aggregate (sum) is greatest. I cannot use rownum since I am using aggregate functions grouping about 50 rows per set. Does anyone know how to limit...

Hello All, I have a query aggregating a result set and grouping by 3 particular identifiers. I'm only interested in the first result where the aggregate (sum) is greatest. I cannot use rownum since I am using aggregate functions grouping about 50 rows per set. Does anyone know how to limit...

Skip, Thanks! PHV, - What do you mean by "End instruction"?

Hello, I'm trying to set up a default when Excel opens up so that when the user starts, 'CTRL-F' default option is within 'workbook'. (The default is within 'sheet'). I know that it's some .Find property I can set up as a Workbook_Open function under "ThisWorkbook" module. But I have been...

I am calling a stored package which has the procedure: Create or Replace Package P1 as created_by varchar2(30); created_date date; modified_by varchar2(30); modified_date date; End; / -- This procedure sets package values since procedures -- can be called from front end -- but packages...

How to pass a procedure for PRE-COMMIT using OO4O Hello. I'm sending over a bunch of Insert statements from Excel straight into Oracle using OO4O. Normally on the database side, I have before-insert and before-update triggers firing which populate modified_by and modified_date columns for...

bump Kind Regards, Edward Apacible International Flavors & Fragrances Ph: 732-264-4500 Ext. 3469 Fax: 732-335-2350

Hello. I'm sending over a bunch of Insert statements from Excel straight into Oracle using OO4O. Normally on the database side, I have before-insert and before-update triggers firing which populate modified_by and modified_date columns for auditing purposes. In Forms, I would populate a...

Here is My Change Event Code: Private Sub Worksheet_Change(ByVal Sheet1 As Range) ' Macro created 11/17/2005 by Ed Range("A43").Select Selection.Font.ColorIndex = 8 Application.Run "DoseResponse_dB_Template_ROUGH.xls!Regression_Analysis" End Sub

Okay, I tried Change Event, Sheet Calculate Event, and Calculate Event. None of them seem to Work. I still have to manually run the macro I made for Regression Analysis. DiD I code swrong? Any other suggestions? Here's my most recent code: Private Sub Workbook_SheetCalculate(ByVal Report As...

Hi, I'm looking for a way to do Automatic updating of Regression Analysis which I have on a spreadsheet. This is unlinke having a chart or cells linked where that is merely an option which is clicked off in calculations tab. Presently I've created a Macro to run the Data Analysis section which...

Thanks guys for both of your help. I used a little of Both types you guys mentioned as such: LoadSheet = Application.GetOpenFilename(&quot;Workbooks (*.xls),*.xls&quot;, 1, &quot;Please find new batch file to Load&quot;) If LoadSheet <> &quot;False&quot; Then Set BatchSheet =...

Hello, I'm trying to set up the beginning of this macro to Prompt the user to pick a file which they want the macro to parse thru. Only problem is the string variable that I am storing still has the path connected to it (ie: C:\Temp\Chosen_File). Thus when the rest of the macro is trying to...

Thanks Jimmy, Thank Access ad-in seems like a good way to go (though they would have to buy the plug-in). It def seems as if Access is a very plausible way to go, but, just want to weigh all options here, does anyone have info about SQL_Server or DB2 - do either of these have statistical...

I guess I'll use the excel Link as a last option then. How about SQL_Server or DB2 - do either of these have statistical functions built into the database? Thanks.

Hello, We are helping a co-partner of our company with a redesign of their data storage and the best program/package set up for their needs. They need to query sets of data (totaling right now in the MB range) and apply statistical analysis and best degree fits for multivariable equations...