Search results for query: *

Hello All, Below is how my data looks like Branch Item Customer Sales 10 1 C1 300 10 1 C2 400 10 1 C3 200 10 2 C1 500 10 2 C3 300 10 3 C1 1200 With this Query SELECT BRANCH, ITEM, COUNT(DISTINCT Customer || '-' || Branch) FROM TABLE1 GROUP BY BRANCH, ITEM HAVING SUM(SALES)...

Hello All, Below is how my data looks like Branch Item Customer Sales 10 1 C1 300 10 1 C2 400 10 1 C3 200 10 2 C1 500 10 2 C3 300 10 3 C1 1200 With this Query SELECT BRANCH, ITEM, COUNT(DISTINCT Customer || '-' || Branch) FROM TABLE1 GROUP BY BRANCH, ITEM HAVING SUM(SALES)...

Hello All, I've gone thru the following thread thread222-38494 which provides a good view of how to send mails from VB thru Lotus Notes. But does anyone know how to automate the Password entry when one does a OpenMail(). Is there anyway where one can automate it to run overnight without any...

Hello All, With the following structures Source Item ID Qty 100 10 101 40 102 50 Target ITEM_ID QTY_SOLD SALE_PRICE .... ... ... Have another table which will contain the Price of each item for Sale Price calculation. One item will have many prices and we should take the...

Hello All, In an Update Strategy Transformation is it necessary to select Insert as well as Update Else Insert in the Session properties. If the Insert is not checked then it is giving an error, but checking both it works ok. Why is that so???? Thanks Sri

Is there anyway by which one can run a program compiled for SPARC on an Intel Solaris Program???? When I try to execute a program I get Cannot execute binary file. ./userlist: Exec format error I did a file command on the program and this is what i got as output. "ELF 32-bit MSB...

Hello All, When an user tries to view CR report over web they are getting the CR Viewer but the report doesn't gets displayed and they are getting a Error initially while loading which reads as :- "The Seagate Software ActiveX Viewer is unable to create it's resource objects. To rectify...

I have a few clarifications on Sql Server Administration. Can you pls help me.. 1. How to shrink a transaction log file? (The transaction log is around 1.8GB and the database is only 400MB. Related dbcc commands did not shrink the transaction log file). I am not using checkpoint to truncate log...

Hello All, Is it possible to make a pick list which is dynamic in the sense it shows the values of a field to reflect new additions to the column on a regular basis???? I'm on CR 8. Sri

Hello All, I'm new to this ASP. So pardon me if this is a silly question. Is it possible to launch Excel Application on the Client PC from an ASP page and show some .xls file if the client doesn't have Excel Installed in his PC???? Excel is installed in the Server but not on the Client PC's...

Hello All, How do one show the sheet hidden when a user clicks on the hyperlink??? I have four sheets with the first sheet say (Index) containing hyperlinks to the other three sheets(Sheet1, Sheet2, Sheet3) which are hidden. The Index Sheet contains cells with Hyperlinks to these three Sheets...

Hello All, Is it possible to get a list of all Oracle Functions from Oracle Database??? Is there any table where all the supported functions of a particular Oracle Database Version is stored??? Any help will be highly appreciated! Thanks Sridharan

Hello All, I'm using MS OLAP Services 7.0 and I have created some Calculated Measures in a cube. I've created a VB application to create local cube from the MS OLAP Server and I'm having problem when I select the Calculated Measure for populating in the Local Cube. All other Dimensions and...

Hello All, Is it possible to add controls(ListBox, ComboBox etc) to a Doc/View App at Runtime based on some condition??? If so, can anyone tell me how to do that?????? Thanks Sridharan

Hello All, I'm having a CRecordset derived class. Can anyone help me how to retrieve the value returned by the SQL Query. I don't want to use CFieldExchange method as my Database Table will change dynamically. When I do GetFieldValue(index, szString) I'm getting only first 25 characters into...

Hello All, I'm using Microsoft OLAP Services for some cube generation. I would appreciate if someone can help me in getting this Calculated Measure done. I have a measure called SalesRevenue and I would like to show the Percentage Contribution of SalesRevenue against the reported Dimension...

Hello All, Suppose I have two excel windows with separate workbooks. How to activate the other excel window from the active excel thru a macro. Thanks In Advance Sri

Hello All, Suppose I have two excel windows with separate workbooks. How to activate the other excel window from the active excel thru a macro. Is it possible??? Thanks In Advance Sri

Hi, Does anyone have a macro which will go to the first cell of a row after applying an autofilter in an excel sheet dynamically i.e. after applying the filter and running the macro it should go to the first row of the filtered value. Sometime it can be A2 or sometime it can be A10 depending on...

Hi, Is it possible to write a file using UTL_FILE package into my local directory (one on my desktop) and not to the directory where the oracle is running coz I don't know the directories available for writing in the server which are supposed to be in INIT.ORA. TIA Sri