Search results for query: *

its SQL Server 2000 8.00.194 - (Service Pack 2) I didnt install the service packs but above is what its says when i do a SELECT @@version The services are running and the specific error occurs when i try to set up an ODBC connection it tells me my sql server does not exist! I can see my...

Hi, I am trying to install SQL Server onto a client windows XP machine. I have installed SQL but my ODBC connection is failing. It cant see the server instance, not even (local). Any ideas on where im goin wrong? Cheers

there is no software install with the printer what so ever. no drivers are installed with the printer no printer appears in 'Printers and Faxes'. so the printer can not be shared on the print server or the workstation. Data gets sent directly to the COM port the printer is connected to and...

Hi there, I am running a small network with Microsoft server 2003, with 3 XP Client PCs and I have a specialist printer connected to COM1 (serial port) of one of the XP client machines. I want to make COM1 available as a COM on the other client PCs on the network so they can also print to the...

Top man Alex, that worked. Thanks very Much! SirGally

Mach_iD Poll_ype Bus_day 3 6 28/12/2006 06:30:01 4 6 28/12/2006 06:30:01 5 6 28/12/2006 06:30:01 2 6 28/12/2006 06:30:01 Thsi is what should appear in the singlemeter table! Thanks

Mach_iD Poll_ype Bus_day 3 6 28/12/2006 06:30:01 4 6 28/12/2006 06:30:01 5 6 28/12/2006 06:30:01 2 6 28/12/2006 06:30:01 2 6 28/12/2006 06:30:01 3 6 28/12/2006 06:30:01 This is Meters The SingleMeters table is emtly with the same three Cols Thanks

Thanks, i think we are getting closer. This is what I have: SELECT Meters.mach_id, Meters.poll_type, Meters.bus_day FROM Meters LEFT OUTER JOINSingleMeters ON Meters.bus_day = SingleMeters.bus_day AND Meters.mach_id = SingleMeters.mach_id AND Meters.poll_type = SingleMeters.poll_type...

Hi there, I almost have my DTS complete. It is scheduled too transfer the past 24hrs entries from one database to another. The only trouble i am having is preventing duplicate entries being transfered. Can I prevent an entry from being copied from the source DB to the destination DB if say 3...

Thank you so much. Thats been a big help. sirgally

Hi there, I need to automate a DTS package to run daily. I have the code Im going to use, only, it is designed for input of a 'start date' and 'end date' by a user. I need the DTS package to pick up todays date and yesterdays date automatically, rather than have the user input these dates. That...

Thanks for the imput guys, Used your method George, worked first time. Thanks

I have a Date/time column in the format 'DD\MM\YYY HH:MM:SS' I need to query the time and not the date, but there on the same column. so for example: Print_Date 30/11/06 15:00:59 29/11/06 12:15:13 23/11/06 06:55:44 I need a query that will give all items printed before 18:00:00 EVERYDAY...