We are planning to do the same upgrade. Has anybody rectified this so we can plan any recommendation in advance?

Hi John

Thanks for your help. We will be doing side by side migration which means parallel running for a while before we take databases offline on old server...

This one works however it gives multiple matches which is not expected. If the table 1 contains less than 20 characters then it will stay as it is and there...

Thanks for the response. Just to clarify table 2 contains correct information however both of these tables are on different servers and I would like to update only table 1...

I had to change few things but try this:

create table #groupings (

ID int,

EventName varchar(255),

Venue varchar(255),

EventDate datetime

)

insert into #groupings

select 1,'Football','Arena','2013-10-04 09:58:42.670'

UNion

select 2,'Football','Arena','2013-10-04 09:58:42.670'

union

select 3,'Football','Arena','2013-10-04 10:45:42.670'

union

select 4,'Football','Arena','2013-10-04 09:58:42.670'

union...

Sorry could you please correct your SQL which populates the table?

yes steve, that could be part of this section. As per example there are many videos on youtube about performance tuning and one by pinal dave was excellent. it was...

yes, it is working in 2005. Thanks. I got it working with dense_rank but it is not the best way of writing if we have this function available. thanks very...

Thanks john and jeff for your input. Much appreciated.

One more problem is the datset i am designing is not on server 2008 so i had to use 2005 where...

Declare @TestScores table (StudentID int identity(1,1), Score int)

insert @TestScores (Score) Values (20)

insert @TestScores (Score) Values (03)

insert @TestScores (Score) Values (40)

insert @TestScores (Score) Values (45)

insert @TestScores (Score) Values (50)

insert @TestScores (Score)...

thanks gail, i already looked into sys.objects but couldnt find any thing like the owner of the table. As you said prinical_id is null.

thanks for the reply, i am not aware of all DBA side activity and just writes t-sql all the time. We dont even have enough access to look into the...

can any one please confirm this that we dont need to pay additional cost for upgrade (2008) if we are under support/maintanance contract for SQL server 2005. ??

create table #temp

(refno varchar(10), sort_order int, primary_code varchar(10), secondary_code varchar(10))

insert into #temp

select '1000',1, 'Q112',''

Union all

select '1000',2, 'W232',''

Union all

select '1000',3,'W343','Y343'

Union all

select '1000',4,'W353','W645'

Union all

select '1000',5,'Q112',''

Union all

select '2000',1,'Q123','T645'

Union all

select '2000',2,'W343','P934'

Union all

select '2000',3,'','W343'

Union all

select...

sorry cliff, it returns different numbers whatever is on the right place. It was typo.

Also there is something called sort_order which puts everything in order when cursor starts. I...