Search results for query: *

Sorry, I didn't say thet I am using excel 2003 Regards

Hi all, I need to "consolidate" a bunch of worksheets loaded with a unique webquery. The data colums are exactly the same of each worksheet. Every time I open the file all the webqueries are executed and loaded on the pre-defined worksheets. The cell range name (except for the first three...

Thanks BobRodes, We do run a screen saver and lock the computer by using GP. We are going to give it a try. Thanks again. Regards,

Hi harebrain, I need just the number of files and the total size (statistics), not the individual filenames (evidence). Your DOS' Dir command gives both, we will just parse the info that we need. We are not looking for who has the new Carmen Electra's picture!!! :) About XML: Probably I did...

Your post is an interesting idea. This brings the next ideas: 1.- Users are requested to lock their computers when they are away, locking is enforced also by policy after 15 minutes of inactivity. It is possible to detect the lock state with VB?. If so, we can run our app and wait until there...

Hi strongm, My group is SQL/Asset Management/Compliance Managment oriented and our experince in VB is limited. The main reason of my post is as the first paragraph states: Exploration and if it feasible. Probably I didn't make the correct question. Let me put it this way. I have been...

Hi all I got a request and I am starting to explore the options and feasibility. The task is simple: To collect the number of files and the collective size of them for specific extensions on a computer. Now you know were this request is headed. Looking for mp3, mpg, wma, jpg, etc. on the PCs...

yikes!!! Analysis Services for SQL Server 2000 Here is the example. Suppose one measure, let say "Ratio"; and two dimensions "Organization". So you have the following Hierarchy for the Organization Dimension: Total Organization (0) | |_Division 1 (1) | | | |_Factory 11 (11) | |_Factory 12...

Hi, This is the scenario: We have some cubes with financial information. We have some variables that are financial ratios. There are very small differences between the ratios calculated by the cube and the ratios shown by the Financial System (0.001 and even 0.0001). Fiancial department...

Catadmin, mrdenny Thanks for your respones. The state of the database is 99% fixed data alredy. So differential population will be fast. The thing here is this is a partial test database, about 1/10 of the production database. When doing the full population mssearch seems very linear when...

Hi, I am text indexing a table with 12Gb of text, 300K records. I am running SQL 2K SP 4 on a Dell 2650 dual 3Ghz CPUs, 4Gb memory. A full population takes about 3 hours, the question here is mssearch.exe is using 100Mb memory and only 3-4% CPU usage. The server has plenty of resources left...

Thank you MDXer, It worked just fine, could you please help me with the following questions. After successfully creating the roles, I added a user with admin rigths over the Analysis Services box. When the user queries the cube, the result is not filtered by the role. It seems that the Admin...

Hi (again) I am trying to figure out how to hide members of a given dimension to the users. We hardcode some members to catch data errors. Now we just want to deny those members to users. Thank you in advance imosri

I found the following: For small cubes it seems it will work just fine. Remember that what I want to do is put two versions (new and old) of the same cube on one server. Go to Analysis Manager: 1. Backup actual cube. 2. Delete actual cube. 3. Restore Old backup 4. Right click on cube, select...

Hi, Here it is the scenario: We create .cab files from one specific cube. Management is asking to bring back a very old .cab in order to compare against the actual cube information. When trying to restore the .cab the only option it gives us is to restore the cube with the original name. Can I...

Hi all, I need some guidance in order to perform the following: In a POS system, I have set a loyalty program to registered customers. At 10:00PM, a stored procedure updates discounts on registered customers based on purchases made in the last 60 days. Here is the view: SELECT...

Fixed!!!! Your second suggestion makes me wonder.... varchar vs a date()? On the query I have to have the result of date() enclosed so, the correct code is: repo.Source = "SELECT mt_fecha FROM m_ticket WHERE convert(varchar,mt_fecha,101)='" + Replace(repo__MMColParam, "'", "''") + "'"...

Chopstik, First suggestion what results I am getting. I query using: select convert(varchar,mt_fecha,101) from m_ticket I got the follwing rows: 09/25/2004 .... 10/22/2004 Second suggestion: the replace function is being put by Dreamweaver MX version 7.0.1. I tried to edit it , If I do...

Hi, I am starting to pull out some reports out of an application The report normally query the database for data of the current day I stripped down the query to focus on the problem. If I run this query on the SQL Server Query Analyzer it runs just fine. select mt_id from m_ticket where...

Donutman, thank you for your comments. Regarding the need of SUM(), now it is obvious that a 1 to 1 is a must. Wondering why the other exercises did not performed as desired I found this line of thinking: Lets say we are inside the update statement where at any given target row has a set of 2...