Search results for query: *

An application was written a few years ago to link to various FoxPro 2.6 tables. It linked to these tables and then used a query to pull the information for various reports. Corporate wants everyone on Access 2k or better for support. We have one machine which has Access 97 just so it can...

I have a remote office wich currently has one XP Pro machine (soon to be 3). At the main office I have a server running Windows SBS 2003 with ISA. Both locations have a braodband connection to the internet. I would like to connect the remote site to the main office as though we had a long...

Using a stored procedure how do I copy stored procedures from one database to another? This would be done weekly and so an automated way is what I am looking for. I would also have to drop them from the target database if appropriate. TIA Mark

I have a web server which needs to get a snapshot of data overnight. On the local machine I have stored procedures which create tables containing changes with a flag indicating that it is an (A)dd, (C)hange, (D)elete or (L)oad. The selection and creation of the change tables takes just minutes...

What is wrong with the following delete statement? I am trying to delete rows from a table on a linked server that exist in a table of the same name on the local server. The following is from query analyzer. DELETE t_remote FROM SERVER.DATABASE.dbo.WEB_EOB t_remote WHERE EXISTS (SELECT...

I am having no luck in executing a stored procedure on a linked server. Is this possible? I am trying the following in SQL Query Analyzer. exec MXW4.CMSTEST.sp_diaryalerts -------------------------------------- Server: Msg 911, Level 16, State 1, Line 1 Could not locate entry in...

I inherited an application which is failing to calculate correctly. I have a table defined as follows: o_labor number (manually entered at data entry) e_labor calculation (number) =sum(extra_labor) d_labor calculation (number) =sum(deduct_labor) r_labor calculation (number) =o_labor + e_labor...

I am getting the following error when producing a report after installing Microsoft XP Service Pack 2. ------ Printing can not continue because this printer is not connected to a port. Use Control Panel to set up a port. ------ The printer is the default printer installed to LPT3 on the...

I have a report which prints daily about 500 pages. I would like to print it in duplex mode to save on paper. The difficulty is that there are breaks by sales person. I need to insure that each sales person starts on an odd page number so the back of a page does not start the next person. My...

I have a patient table, a provider table and a return to work (RTW) table. Both the provider and RTW tables may have many rows for each patient, or none. I am trying to put together a select statement which will return the patient information and the most recent provider, based on begdate, and...