Search results for query: *

We are running a i5 series V4 IBM server and we use SAP as our ERP. The SAP program generates some text files that are saved on some specific folder. The remote client FTP's to our server and grabs the file but they are having security issues where they cannot grab the file. I check permissions...

We are in the middle of a new SAp implementation. I never worked on SAP nor AS400. We are finishing one of the third vendor interfaces that requires importing a fixed size text file into SAP. The file is created in a unix system ( that is all I know about the remote system). I can open the text...

is there a function to find numbers in a string? Varchar type or any kind of stirng type? We have a large item master table for wines. In the original design, the vintage was included in the description. I am trying to create a second column with the vintage. I already know that this won't work...

I need to write a query that will split a text field after the first space found, i.e: if the contents of the text field is 'red small car 4 door' the query will return 'small car 4 door' thanks in adavance for any help

We get a file on a daily, weekly basis. I need to import that file into our MS SQL server 2000 database. The file that comes in has a period column which (for instance: '2005-02') The file has sales for the same period only so all items in that column will be the same. I need to read the file...

Our Exchange server went down (EX 2k Standard SP3) due to a hard drive failure on our RAID. Windows never went down but it seems like Exchange was trying to commit a log file to tha database when the disk failed. We recovered the database sucessfully using the eseutil command with diffrent...

This may be an easy one I have a price table with different dates. The prices apply according to the current date. The table is mor eor less like this: price item_no effective_date end_date region price 1 12/01/1992 null NY 120 1...

Let's say I have to small tables customer id name 1 cust1 2 cust2 3 cust3 4 cust4 Sales inv# custid date sale 1 1 2004-12-03 $203.56 2 1 2004-12-04 $405.67 3 2 2004-12-04 $304.68 4 3...

Is there a way to run a DTS package from a stored procedure? The idea is to trigger a package from an ASP webpage. The Package cannot be shcedule because it has to be run by a user that needs to finish some tasks befero he can run the package. If there is a way can you post the code to create...

Our company just finished the purchase of a small company and we will start the process of merging the two databases. The small company is using AS400 (I'm have no info of equipment nor OS version). I'm just going ahead of the game doing research. We have a Alpha DS10 running open VMS 7.3. We...

We have a Sales History table that is on our DB for reporting purposes only. The problem is that it has a really bad design and I am tryin to fix a it a little for better data manipulation. The table desing is as follows table sales customer# Item# jan04 feb04 ..... jan03....jan02 ...dec01 1...

Is there a way to request a read receipt from an email task on a DTS package???

This could be a simple query. I'm just stuck on it. I have two tables (this is no t the best design but I'm wondering if I can't get the result that I want) sales_table (this holds sales YTD) brand division region cases_sold ----------------------------------------------- brand1...

Hi all I'm trying to create a sales goal table My current query looks like this select brand, goal, state, goaljan, goalfeb-((salesjan-goaljan)/11) as goalfeb, case when month(getdate())>=2 then goalmar-(((salesfeb-goalfeb)/10)+((salesjan-goaljan)/11)) when month(getdate())=1 then...

Hi all I am trying to group sales by month creating new columns by month. Right now if I run my query like this Select period,brand,division,sum(cases) as cases From sales_table group by period,brand,division order by brand,period,division and the result is period brand division...

I'm trying to select a gruop of items within a group Suppose I have two tables. A brand table (brandtable) id Decsription -- ----------- 1 brandA 2 brandB 3 brandC an Item table (itemtable) id Description Brandid -- ----------- ------- 1 item1 1 2 item2 1...

How do I move an email address from one user to another?

I'm working on MS-SQL 2000 and I'm trying to calculate the last day of the previous month, i.e.: Today's date is 12/10/2003 after running the query using today's day as parameter I will get 11/30/2003 Is there a MS-SQL 2000 functions that can do this or has to be calculated with a whole bunch...

I'm running a query on a MS SQL 2000 server and one of the fields has a lot of NULL values. I'm putting the output into a tab delimited file so the result has to be cleaned up before saving the file. The following is the Query I'm using but I still cannot get rid of NULL values on the LAST_COST...

We have a table where we keep track of inventory received from our suppliers. Obviously the table can have multiple entries for the same Item but their dates and Qty received are different. The table should look like this: Table receipt item_id Qty Date_recived 1 20...