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 Rhinorhino 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: earthandfire
  • Content: Threads
  • Order by date
  1. earthandfire

    Self searching a table

    SalesTable includes the following fields: SalesDate datetime Customer int OrderNumber int NewCustomer bit The requirement is to set the NewCustomer field to 1 where this is the first sale to a customer for 4 years (or this is a brand new customer) The table contains all sales data...
  2. earthandfire

    Congratulations ThatRickGuy

    on your 300th star here in VB.NET [vampire][bat]
  3. earthandfire

    Join/Where

    I thought this was going to be straightforward, but I've tried every combination of Join and Where that I can think of and I'm beaten ... ... ... DECLARE @clno int DECLARE @chno varchar(22) DECLARE @repdt datetime CREATE TABLE #currentclaims(claimno int) INSERT INTO #currentclaims SELECT...
  4. earthandfire

    Locking a record

    I have a table with two fields type and number. I need to fetch the current value of number (for a given type) increment it and save it back into the table - returning the new number to the caller. However there could be several (10s or even 100s) of "simultaneous" requests for a new number...
  5. earthandfire

    Inserting Records from table on one server into table on another

    The following code: TRUNCATE TABLE SVUKSWIPC002513.DealerAuditData.dbo.F5W03 generates the error: The object name 'SVUKSWIPC002513.DealerAuditData.dbo.' contains more than the maximum number of prefixes. The maximum is 2. If I remove .dbo, it complains that it can't find a database called...
  6. earthandfire

    Truncating Transactional Log

    Is there a way using TSQL to truncate the Transaction Log? [vampire][bat]
  7. earthandfire

    ActiveX Resource Library

    Is it possible to create one or more ActiveX scripts that can then be referenced by an ActiveX task in a package. The idea is to create a library of commonly used funtions and not to have to type (or copy/paste) them into each script when they are needed. Thanks for any help. [vampire][bat]
  8. earthandfire

    IMPORTANT: Please specify which verion of VB you are using

    Although there are many similarities between 2002/2003 and the new 2005, there are also enough differences to cause problems. Many things that were difficult in 2002/2003 are now just one or two lines of code in 2005. When you ask a question, those who attempt to answer will often create a...
  9. earthandfire

    Are ScrollBars Visible?

    Whilst working on the TGML exercise, I came up against the problem of being able to identify when ScrollBars are visible. I think this has been asked here before, and I'm not sure that there has been answer. I've tested this with RichTextBox, ListBox and TreeeView and it seems to work...
  10. earthandfire

    TGML

    ZmrAbdulla posed a problem in thread796-1152284, which both ca8msm and I found very interesting and intriguing. In one of his replies ca8msm sugested that it would be a good idea if we could have a mechanism to embed colour tags between [code] [/code] tags. This got me thinking. I can see two...
  11. earthandfire

    Button1.Enabled = False DOES NOT mean Button1 is disabled

    There seems to be a lot of emotion regarding whether or not it is valid to use Application.DoEvents The following code block is a time consuming process: Private Sub ProcessTakingALongTime() For a As Integer = 1 To 10 For b As Integer = 1 To 100000000 'do something really...
  12. earthandfire

    Date Logic

    I'd like to confirm (or otherwise) my understanding of dates: Assuming a field called MyDate (datatype datetime) (UK date format) 1: MyDate >=CONVERT(datetime,'01/05/2005',103) will include ALL records for 1st May 2005 and subsequent dates 2: MyDate <=CONVERT(datetime,'31/05/2005',103) might...
  13. earthandfire

    Bristle

    Along the lines of SantaMufasa's Utahnics .... Bristle is a major city in the UK with its very own language. Local author Dirk Robson has written a number of books on the subject, his most well known being Krek Waiter's Peak Bristle. One of his later books, Twenty Sentries of Bristle is a...
  14. earthandfire

    UK Postcode as a continous string

    CorrectPostCode = Left(WrongPostCode, Len(WrongPostCode) - 3) & " " & Right(WrongPostCode, 3). Regardless of how many characters in the postcode, it consists of two parts an Outcode and an Incode, the second part is the Incode which is always three characters Number, Letter, Letter. Hope this...
  15. earthandfire

    English pronunciation

    I've looked both on this forum and Making An Impression and am surprised that no one has yet offered ghoti for discussion.

Part and Inventory Search

Back
Top