Search results for query: *

We are in the process of migrating to Exchange. My mail box has been moved but most other people in the company havn't, as yet. I have rules running in outlook to move e-mails into sub-folders depending on who sends it or who it was sent to etc. All my rules work as planned but any e-mail sent...

I have two jobs running on my server that import data to my database. The first step of the first job writes a value to a table when it starts and removes that value when it ends correctly. I need the second job to test if a value exists in the table and error if there is a value there. So...

Hi, My database runs a weekly import job followed by several stored procedures to re-format and calculate on the imported data. This job has been running weekly for a couple of years now without any problems. The data I import each week has grown a lot over the last few weeks and I am now...

Hi, I have the following data in a table ID CatID SubCatID Description 7 7 0 Sprinklers 8 8 0 Intruder Alarm 9 9 0 Air Conditioning 22 9 1 Fans 23 9 2 Pumps I'm writing a stored procedure to...

Hi, I am dealing with the SQL side of a Visual Studio project that is being developed further. I have copied the existing live database to a development server to build the new structure. What I need is to be able to script the changes to the structure to deploy them to the live server when...

Hi, I haven't, as yet, used SQL 2005 and want to know if SQL Server Management Studio is the same as Query analyser? We are having an system written for us and the company are suggesting that end users use SQL Server Management Studio to maintain the data in the tables rather than having a...

I have the following stored procedure CREATE PROCEDURE Test @LocationID int, @StatusID int, @Area int, @Contractor int, @EnteredBy Varchar(20) AS BEGIN SET ROWCOUNT 30 SELECT dbo.Calls.LogID FROM dbo.Contractor INNER JOIN dbo.ContractorOrder ON...

Hi, I hope someone can help with a query on a stored procedure. Records being displayed in our application are split into pages of x amount of records. x being a value (default of 30) that is user specified. I have a stored procedure that takes the @NumPerPage from the user and divided the...

Hi, I have a table as follows ID Month Year 13 Mar 2006 17 Apr 2004 18 Sept 2004 19 Mar 2007 19 Sept 2004 20 Dec 2004 21 Nov 2007 23 Mar 2004 24 Mar 2005 25 July 2005 25 Oct 1998 26 May 2006 28 Apr 1999 28 Sept 2005 29 Apr 2006 29 Feb 1999 30 June 2007 I want to select from this just...

Hi, I have a stored procedure to get some call information from a couple of databases. I want to join two tables on the column OrderID, the problem I have is that on the ContractorOrder table OrderID is an INT and on Calls it is a VARCHAR. What I want to do is to limit the join to only look...

Hi I have the following storec procedure -- CREATE PROCEDURE CallsEnquiry @LocationID int, @StatusID int, @Area int, @Contractor varchar(60) AS BEGIN SELECT dbo.Calls.LogID, dbo.Calls.EnteredBy, dbo.Calls.Entered, dbo.Calls.LocationID, sz.dbo.Location.Branch...

Hi, I hope some one can help me out, I'm a bit rusty on NT configuration. I have a HP DL380 G2 server which I have just installed as a BDC, to get the server to join the domain I had to put a 3Com network card in as, even with using HP SmartStart to install with, it didn't recognise the...

I understand that 2003 server will run in 'mixed mode' and work with a NT4 domain. I have a question to ask. I currently have a small network running a NT4 domain, we are replacing our servers and would like to install 2003 server but we do not want Active Directory. Can we run 2003 in mixed...

Hi, I've got a query that I hope someone can help with. We have recently upgraded a user from outlook 98 to 2000. Outlook 98 had an LDAP plug in as it didn't come as standard with 98. I removed LDAP from add/remove programs and then removed outlook 98. I then installed outlook 2000. The...

Hi, I'm wanting to do a query with a group by statement to group some text field together and can't think of a way to do it. Have a look at my sample data below orderid Detail 26146 Attendnace on 27/11/06 to repair fire alarm 26147 Key holding fee 01/07/06 - 30/06/07 26148 Hardware Maintenance...

Hi, I have a strange query on Excel 2003 and the way it displays the formula bar. If I put the following formula in a cell +(3000/13)*4 I get the answer 923 in the cell. If I click back onto the cell what I would expect to see in the formula bar is =+(3000/13)*4. On a blank spreadsheet...

Hi, I have a very frustrating problem that I need to get fixed. We have several spreadsheets, created using a data extract from our payroll system in Excel 8.0 format, that won't open in Excel 2000. What happens is that it looks like it is opening but all we get is the blank grey screen (as...

I'm having problems with a calcualtion across two tables. My query is update salesperformance set salesperformance.Yr1RYTD = (COALESCE salesperformance.yr1running,0) - COALESCE(salesperformance.yr2running,0) + buildsalesperformance.yeartotal) from salesperformance left outer join...