Search results for query: *

Dear Sir Or Madam, I have a problem with a Microsoft application when user enters a batch hit save the batch the application just run and run, never returns. I would like to run a SQL Profile Trace just for that specific process so I can see what is doing.. can some please tell me what steps I...

Thanks for your response, In addition I want to update the column, would that be posible, the column is char(3) not null. Thanks again... Jim

Dear Sir or Madam, Thank you in advance... I have a Remittance column in the Vendor table with a Upper and Lower case letters, other with lower case letter only for example ReoDec madec I want to convert all the data in the Remmittance Column to UPPER CASE. HOw can I do that? Thanks Jim

Dear Sir or Madam, We have about 50 Agencies with our company around US. The reports managing is getting very difficult. We are trying to standarize all reports all agencies will use the same reports. I need to create a repository were everyone in IT knows which reports to install on every...

Dear Sir or Madam, I have the below query that extract data out of direct deposit and place it into another table, the query is not running for me. Woul you please review the query and assist me to find the problem. Appreciate your assistance in advance. Thanks James declare @empid as...

Dear Sir or Madam, I have the below query that pulls Direct Deposit Info by Employee. I am trying to place a case statement that will replace if then 01 etc. but I am not getting the results in the case, would you please review the statement, I really appreciate your help in advance James...

Sorry for the misunderstanding. I have completed the task. Appreciate everyone answer. Thanks James

Dear Sir or Madam, I am writing a simple query where I need to hard code the CompanyID to MBSCA. How can I do that.... Thanks in advance. Cheers, Jimmy

Dear Sir or Madam, I have 1 purchasing form designed in Crystal, this form is shared by 2 companies (company A) and (company b). I am trying to add a code that when users print the form, prints the correct company logo - how can I acomplish that with an IF statement? Thanks in advance for...