Mike,

The sequence table mentioned by the previous poster works very well in most cases. I work quite a bit with a large Point of Sale application that uses this...

I agree with Jeff on this one - run it in steps as a script to find the area of the problem. That being said, there are only a...

I would think the easiest way to do this is add a day to the date and compare the month. Something like:

SELECT * FROM #tmp

WHERE DATEPART(month, LockEndDate) = DATEPART(month,...

I'm kind of with John on this one. If re-compiling takes that long for just 100 or even 1000 iterations, then this must be a monster of a procedure....

Paul,

That's what I get for going through the forum at 2 AM. Ooops!

Todd Fifield

Victor,

Just change your date comparison from:

AND t2.DataYear < = t1.DataYear

to

AND t2.DataYear BEWEEN t1.DataYear - 5 And T1.DataYear

Todd Fifield

I think a better solution would be to create a temp table to hold the contents of the update statement and then use the OUTPUT clause in your update statement....

James,

I've written a couple of articles here on using calendar tables to simplify code and better performance. I use them extensively when applicable. One of the keys to...

I had a client switch over to SSD's for most of the storage on the instance. The first database moved to SSD was TempDB. We didn't see much...

SELECT INTO runs much faster than CREATE TABLE/INSERT INTO in most cases - especially if the created table has constraints or indexes, which will have to be maintained during the...

To Reply to Kevin on why the UDF rather the in line code:

I recently used this type of iTVF to build a keyword list from item descriptions from order detail...

Please post a use case and an example of the expected output.

Todd Fifield

I'm not a big OpenQuery or OpenRowSet guy and I haven't used SSIS all that much. I have, however, done a fair amount of BULK INSERT type code from...

If you will have to do this sort of thing more than once, I highly recommend setting up a monthly calendar table to make coding much easier and increase performance.

Here...

I have an aversion to directly manipulating data in my database from another source such as a text file.

I would use Jeff's suggestion and bulk insert from the text file...