Fortunately there are no 2 word countries in my data . As I mentioned though, the Replace function doesn't seem to have any...

Not sure about the percentages calculation, but in profiler you could set up 3 traces, you could specify in the filters tab in one TextData Like Select , another like...

Hi RGR,

Yes I've removed the Where criteria, I'll check some of the other items you mention

Cheers

Hmmm,

I'm wondering whether it's down to the fact that I'm using SQL 7.0 in 6.5 compatibility mode or mayber it's a database setting somewhere

Select replace(country,' ','') AS SPACEFIELD, replace(country,' ','Z')...

No I'm afraid that didn't work RGR, If I issue

REPLACE(address,' ','Z')

I get FZRZAZNZCZE, so It is recognizing the ' ' as a space in the first parameter

It would seem that...

At the risk of repeating myself

SELECT  A.Store_id, A.Store, A.Region, A.[% Chg Cap],A.[% Chg Rad]

 FROM Performance_Variance A

 WHERE A.[% chg RAD]< 0

   AND...

I had no idea that you could call a DTS package like that, thanks Mike

Hi Luke,

How about

SELECT  A.Store_id, A.Store, A.Region, A.[% Chg Cap],A.[% Chg Rad]

 FROM Performance_Variance A

 WHERE A.[% chg RAD]< 0

   AND A.Month_end = '2005-09-14 23:59:59'

   AND A.Level = 'store'

   AND A.store_id IN

  (SELECT...

Nope spoke too soon, still getting the same Error

Thanks David

Are these id's identity columns?  If so you could use @@identity which stores the last identity value inserted

Declare @lastid as integer

Set @lastid = @@identity

Thanks Phil, that's perfect

That looks promising Noel, I'll give it a bash and let you know how it goes

Hi Yelena

The registry key is HKLM\Software\Microsoft\Microsoft SQL Server\<instance name>\MSSQLServer\Parameters on my installation.  But the server names and instance names and drive mappings should remain the same.

One further question.  Our Tempdb...

Thanks James, I had suspected as much - A shame really 😉