Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. imosri

    How to create a long list from a lot of worksheets.

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

    How to create a long list from a lot of worksheets.

    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...
  3. imosri

    Scanning files

    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,
  4. imosri

    Scanning files

    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...
  5. imosri

    Scanning files

    ...3,000+ mp3s in 50 seconds, much, much better. To our use, from the result, only one row is useful 3801 File(s) 20191379350 bytes (using dir *.jpg /S /-C) We can collect from every generated file that specific row. We can try that... Finally, XML formating of the results is just...
  6. imosri

    Scanning files

    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...
  7. imosri

    Scanning files

    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...
  8. imosri

    How to insert values at higher levels of the Hierachy

    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...
  9. imosri

    How to insert values at higher levels of the Hierachy

    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...
  10. imosri

    Populating text index takes too long....

    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...
  11. imosri

    Populating text index takes too long....

    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...
  12. imosri

    How to hide dimension members?

    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...
  13. imosri

    How to hide dimension members?

    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
  14. imosri

    Restore an archived database under a different name?

    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...
  15. imosri

    Restore an archived database under a different name?

    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...
  16. imosri

    Loyalty Program / Customer Information /Help with Query

    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...
  17. imosri

    querying a datetime field

    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, "'", "''") + "'"...
  18. imosri

    querying a datetime field

    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...
  19. imosri

    querying a datetime field

    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...
  20. imosri

    Updating multiple rows

    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...

Part and Inventory Search

Back
Top