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...
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
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...
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...
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...
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
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...
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
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...
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
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...
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)...
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
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...
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
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...
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...
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.