Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: anorthcote
  • Content: Threads
  • Order by date
  1. anorthcote

    Outlook 2003 Rules on Exchange server

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

    force error in stored procedure

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

    Full transaction log

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

    sort order query

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

    Depoly changes to structure

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

    SQL Server Management Studio

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

    Slow Stored Procedure using ROWCOUNT

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

    Decimal places lost in division

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

    Select newest date from table

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

    Join stored procedure help

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

    Stored Procedure Null problem

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

    Network card setup

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

    NT4 Domain 'mixed mode'

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

    LDAP problem after migrating from outlook 98 to 2000

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

    group by

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

    Excel 2003 Formula Bar

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

    Excel 2000 Won't open spreadsheets

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

    calculation across tables

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

Part and Inventory Search

Back
Top