Search results for query: *

Thats great, thanks so much for your help.

No the quantities are not always the same. Basically the quantity is the number of faults on that particular roll so this can change for different Batch numbers. It can also change for the same batch if faults get removed or combined together. e.g roll 5 has 5 faults but combine 2 faults...

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...

That works a treat, thanks Ryan. Thanks all for your help.

The table is sorted by Batch, Roll and Fault_str so the lowest starting fault for a roll is always first. Faults can never overlap.

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...

Thanks for the info but I've already tried this solution and as you mentioned the mouse is still functional so if they click the mouse button it will get focus on which ever textbox etc that the mouse is over which will cause problems. I really need a global disable of all mouse clicks?

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...

SQL Services are set to start with the local administrator. I've now changed the password of the local Administrator to be the same as domain\administrator and it has fixed the problem. THANKS for your help

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...