Sounds like the stats are not up to date, like the optimiser does not consider that...

OK so I guess we both believe the 2005 box should be faster.

How did the DB get transferred?

It sounds like you have both a 2000 box and a seperate 2005 box.

Are they equivalent spec (proc, memory, disk subsystem) and under equivalent load?

So the address_number changes _and_ the communication_number (otherwise we would not be having this discussion).

How about

SELECT TOP 400

IDENTITY(INT,1,1) AS Number

INTO

#Number

FROM

master.dbo.SysColumns sc1 CROSS JOIN master.dbo.SysColumns sc2 -- 12 million...

Ok I'm following slowly. Where do the values other than address_number come from. Please tell me they are not hard coded into your script!

Is there a way in SQL to say update all address_numbers from the communications table with the other values shown in the statement (i.e. the website address etc), where the...

This sounds like the address_number is your primary key on the table. Using an IDENTITY column would do away with the neeed for you to update the column manually.

Is value of the address_number column unique on the table?

Hi Jon,

Not sure I folllow what you are trying to do.

If you need to load a csv I would use DTS or SSIS.

Allen

102 in a convert statement expects the date to be like this yy.mm.dd, you need to change the order of the dd mm yy parts of the date before passing...

Try something like this

DECLARE @MyDate NVARCHAR(6)

SET @MyDate = '112807'

SELECT CONVERT(DATETIME, SUBSTRING(@MyDate,5,2) + SUBSTRING(@MyDate,1,2) + SUBSTRING(@MyDate,3,2),101)

Hi dbaltazar

From BOL

Your code does a FETCH (the second FETCH on rs2 ...

A couple of observations.

1 cursors are slow.

2 the check on @@FETCH_STATUS, should this be done after the first fetch, I think the fetch loop will never end?

Allen

From what I understand if nulls are allowed the on disk data adds a supporting column consisting of a bit map that identifies which columns in a particular row are...

This script is pretty good.

http://www.sqlservercentral.com/scripts/Miscellaneous/31574/