Search results for query: *

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

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

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

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

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

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

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]

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

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

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

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

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

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

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

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