Search results for query: *

I have a query which calculates distances between faults on a roll of material but I only want to show the minimum distance and not all distances between each fault. Can anyone help please. My query is below select batch, roll, Faults as Quantity, isnull((faultstart - (select top 1...

I have a table listing faults on rolls of material and need to work out the distance between faults on the same roll and create a new table with the results. Current table Batch Roll Fault_Str Fault_end 8701 1 2 3 8701 1 6 8 8701 1 10...

We have a VB6 program running on our shop floor which has been written for use without a mouse and follows strict paths through the program depending on keypress' which works fine. The problem is that the shop floor operators now need to run other applications on these computers that require a...

I'm trying to run a query which searches for a - in a field then selects all characters before the - If I use the patindex in a select statement it works fine but as soon as I use openquery command I cannot get it to work. Can patindex be used in an openquery statement or is there an...

I'm running SQL Server 2000 and have created a DTS which runs a query to pull data from Informix into SQL. The DTS will run if I manually execute it from the SQL Server but errors out with the following error when I schedule the DTS. [Informix ODBC Driver]Unable to load Translation DLL. Thanks...

We are using SQL Server 2000 with Windows 2000 Server and using Win NT authentication. We back up our databases to another server using a mapped network drive. We have now changed our NT administrator password and since have not been able to backup across the mapped network drive in SQL.The...

I have created a Stored Procedure to select a range of records between certain dates in Informix 7.3 as below, but when inserted into Crystal Reports 8.5 and executed it returns 10 records instead of 54 records. Any ideas? Thanks in advance. CREATE PROCEDURE invoice_valuation (sdate DATE, edate...

We have a DHCP and PDC server in the UK in which our site in Germany also log onto over the router. The problem is that we have had to setup the german user's using static IP addresses as it won't collect it from the DHCP server. They are able to logon to the network using our PDC though over...

I'am trying to speed up our crystal reports by using stored procedures but I had never heard of stored procedures until a couple of days ago. I have managed to create a stored procedure over 1 table selecting multiple records but can't get it to work over 2 tables. The code for 1 table is below...