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!

  • Congratulations strongm 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. Jimmy24

    Create Multiple Columns in a Table

    Dear Sir or Madam, Thank you in advance for your assistance. I have 1 table A in Microsoft access. This table contain only 3 columns. In the table the data reads like Here what I have LOGID BTID MESSAGE 25 91 SEQ_MEMB_ID: 7836648; RSTORE_SEQ_ID: 7192656; I need to create a new...
  2. Jimmy24

    using sp_help_revoklogin in a new server.

    Dear Sir or Madam, I have restored 2 new database into a new server, this new server has not login, I need to run sp_help_revoklogin, do I need to run the sp on the old server or the new server. I am a little confuse how to use the sp. Thanks in advance for your help
  3. Jimmy24

    Restore database from different server

    Dear Sir or Madam, I need to perform a full database restore to database D1 on Server SQL Server US1. I need to get my backup "D1_backup.dmp" from Server US2. Can you please provide me some assitance with the syntax. I appreciate your assitance in advance. Thanks James RESTORE DATABASE D1...
  4. Jimmy24

    S

    Mr. Paul, SInce both queries are pointing the same database can I place both queries just the way I described below or I need to add something else at the beginning such as exe etc. I appreciate your advice. UPDATE gltran SET gltran.user1 = apdoc.user1 FROM dbo.APDoc INNER JOIN...
  5. Jimmy24

    S

    Dear Sir or Madam, Do i need to write a store procedure first or just the queries.... Jimmy
  6. Jimmy24

    S

    Dear Sir or Madam, I have the following SQL queries that I need to schedule to run every night via SQL Enterprise Manager. Would you please provide me an advise how is the best way to do it? I appreciate your help in advance. Jimmy UPDATE gltran SET gltran.user1 = apdoc.user1 FROM...
  7. Jimmy24

    IIS User

    Dear Sir or Madam How can I check which users are currenly connected to my IIS server? Thank You in advance. Jimmy
  8. Jimmy24

    Truncating filed from 30 or more to 30 less

    Dear Sir or Madam, I have a field called name that the length is 30, I have some names that a very long over 40. I need to truncate those names that has more than 30 caracters to make them 30. Would you please assist. Thank you in advance James
  9. Jimmy24

    Microsoft.Jet.OLEB.4.0 code identification

    Dear Sir or Madam, I have an excel spreadsheet, every cell contains the below code under query. Would you please tell me what is the purpose of the code... Regards, james Provider=Microsoft.Jet.OLEDB.4.0; User ID=Admin;Data Source=H:Emp phone directory list.xls;Mode=Share Deny Write...
  10. Jimmy24

    PTO Accrual Calculation

    Dear Sir or Madam, I need to create a calculation in Cognos that provide me with a PTO Accrual. I am wondering if someone be so kind and guide me how to create this calculation... Regards, Jim
  11. Jimmy24

    script to modify Excel Security macro from High to low

    Dear Sir or Madam, I have the following excel macro that copyies our employee phone list. We have about 17,000 user that are using this form. The problem I am having is the security tab under tools==> macros==>security is setup to high to all 17,500 user. Would you please be so kind and tell...
  12. Jimmy24

    renaming databases

    Dear Sir or Madam, I have a SQL db that I need to rename from SIVApps to MISIVApps. How would be the best way to do it? Thank you in advance for your assistance. Regards, Jimmy
  13. Jimmy24

    Creating a macro to hide a colum B of spreasheet

    Dear Sir or Madam, Would you please assist me with the following task. I have the below copydata macro, that refreshes data from another worksheet, I like to be able that after finished refreshing the data to hide the entire column B. Would you please advice. Thank you in advance Sub...
  14. Jimmy24

    Copy db from Production to testing!

    Dear Sir or Madam, I have a current production enviornment of SQL 2000 with about 60 databases on SQL server A. I have finished building a SQL server B for testing and I would like to copy 2 of the databases from production into testing. What would be the best way to do it. Copy 2 (db's)...
  15. Jimmy24

    IIS setup timout.

    Dear sir or madam, I need to setup IIS timeout when the webpage is in idle for more than 30 sec to timeout. WOuld you please advice how to do it. Regards, Jimmy
  16. Jimmy24

    Database Restore Failed

    Dear sir or madam, I am trying to restore my database from last night back up. Currently my back up run every hours and is listed as follow: NAVApplication16_00.TRN I need to restore from this specific time,and I do the following steps: 1. Enterprise Manager - right click on the specific...
  17. Jimmy24

    Adding a new field to a tables view

    I have a table under views named vw_members MemberID MemberName MemberAddress I need to add 2 more columns to the table SegoID SegoName How can I update the table with the new columns I really appreciate your assistance. Regards, Jimmy
  18. Jimmy24

    Add Security to a crystal report

    Dear Sir or Madam,. I have a report group by Division and Department: example Division = 6A Department = Accounting Member= John Doe, Margaret Doe, etc Division = 6A Department = Marketing Member= Pete Doe, Sarah Doe, etc I like to add a security on the report if John Doe only...
  19. Jimmy24

    Automate Schedule and Export Report to Excel

    I have a report in Cognos for Members Phone List. I want to automate the process and do the following: 1.Write a macro to automaticaly export the report to excel. 2.Create an schedule that run everyday at 9:00 am the automaticaly create the export that goes to excel. Please any help will be...
  20. Jimmy24

    Calculation Criteria on Join Date Field

    Dear Sir or Madam, I need to pulled data where that will includes all members that with join_date is greater than specific date. Example: All member with join_date greater than 11/12/2005. Select * From Members Where ????????? Thank you for your assistance Jim

Part and Inventory Search

Back
Top