Search results for query: *

When I placed an order on hold a record created in sop10104 with a hold date of 7/30/2015. when I release the order today, GP update the hold date to 8/13/2015. Does GP move the original hold date 7/30/2015 to another table or just simply update the date? Your help is greatly appreciated...

i'm using Acess 2003 front end and backend is SQL Server 2000. i created a blank database and link it to SQL Server via ODBC. i'm trying to create form so the user can search/update/add record to a table. on the form header, i have a combo box base on the task table, once the user select a...

I need to collate all data by company and accounts for the current year. you can see from the case statement that i want to aggregate the amount from the beginning of the current year up to last month of the current year. however, when i get to Jan of a new year i need Dec of the previous year...

hello experts, i'm creating a simple form for my user to add data to a sql table. on the form i have a combo box that pulls the emp_id from the employee table. i also have 2 text boxes. text box1 displays employee first name and text box2 displays employee lastname. the values in the two text...

Hello All, I'm using CR version 9 and Oracle 10g. How do I get Crystal Report to use stored procedure as a source for the report? Any help or suggestion is greatly appreciated.

I just install Oracle 10g to my laptop. the installation was successful. the last step, i change the password for the System and Sys accounts. Now when i try to connect to Enterprise Manager in IE using either account, i received a message indicates that these accounts were locked. can you...

i have a table with the following data structure: category instance nbr out of bal 1 8131234567 out of bal 1 7272345678... what i'm trying to accomplish is get the result in this format: category instance nbr out of bl 2...

i'm trying to export a total from a sql table to a specific cell of an excel sheet. for exampl, select total_amount from tbl_total to cell b24 of an excel sheet named DATA. right now i have a data pump between a source connection and an excel connection but not sure how to accomplish his. any...

how do i modify a class in the library and save it? i'm a newbie to vb .net and do not know how to accomplish this. any details information or links that i can learn to accomplish this is greatly appreciated. thanks

We have a front end application written in C++ connect to a SQL Server. We just did an upgrade and receive this error message 1. error message on apps log: file: database.cpp; line number: 14674 22007 0 [Microsoft][ODBC SQL Server Driver]Invalid date format we contact the vendor and they...

is there a way for me to identify which DTS Package a scheduled job is executing? for example, i have a scheduled job named JOB_DTS_Account. within this server, i have three DTS Packages: DTS_Account, DTS_Account1 and DTS_Account2. i want to remove two out of three DTS Packages but not sure...

I have SQL 2K Dev Ed installed on my laptop. The IT person decided to rename my laptop. Now everytime I boot up, I revecie this message: "your sql server installation is either corrupt or has been tampered with (unable to load SQLBOOT.DLL)." I cannot start the local server on my laptop. I...

Can you please help me understand why use synonym instead of view. My understanding is if you create a synonym, then you don't have to specify the schema owner and the users do not know the real objects that they are referencing. Same idea with using a view. You create a big temporary table...

i have a result table that stores the data for my report and a calendar table that stores weekend and holiday. the result table has the following attributes: account_id account_status status_creation_datetime what I need to do is select all attributes from the result table. However, I have to...

Is there a function or a way to convert the WORKDAYS function in Access to T-SQL. This is what I have currently have in Access: Days in Error: WORKDAYS([creation_date]],Date()) basically, I would like to find the number of days between the creation_date and the current date excluding holiday...

I have a result table with the following data layout (no key field, this is it): As_of_Date Email_Created Email_Sent No_Subscribers 9/11/2003 121 70 485 9/18/2003 180 87 1308 9/25/2003 249 148 2460 etc...

Hello All, here is a sample data in my table: account_id transaction created_date 2025 846011 2003-08-14 07:28:12.037 2025 846012 2003-08-14 07:28:18.300 2025 846013 2003-08-16 20:18:25.253 6375 319711 2003-08-19 18:02:16.503 6375...

I've a table that will always stored ten rows of data. I've a DTS package that run weekly to populate this table. What I'm trying to accomplish is remove the oldest row from the table in order to keep the number of row = 10 at all time. For example: As_of_Date Category 9/11/2003 Hungry...

I have to perform a division on two field to find the average. example: tbl.contact / tbl.count How do I check to ensure that when tbl.count is 0 then don't perform the calculation? I've tried the following but it doesn't work: DECODE(tbl.count, tbl.count > 0, tbl.contact / tbl.count,0 ) the...

i'm trying to create a DTS pkg to use select account info from a table in oracle only if the account is exists in the SQL.lookup table in sql server 7. this is the syntax SELECT account_id, cust_ratings FROM Ora.account_info OAI WHERE EXISTS (select * from SQL.lookup where...