most of the time is spent clustered index update (98%)

If you want to make the updates work fast ..

delete the clustered index . run the update query then create clustered index on...

Explain the problem clearly.. I dont think its pivoting a table.. if that is the case I saw so many solutions in this forum only

I think Query is perfect ( I assume passwd as char type and ident as integer)

Tested with the same scenario explained by you, my machine is taking less than minute to...

I didn't get you.. what does it mean?

Replace the following statement in the function

Added space to every title

SET @STR_INIT =LTRIM(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(@STR,'Mrs ',''),'Mr ',''),'Dr ',''),'Rev ',''),'Ms ',''))

This will guarantee you, if any person have the name with the title...

try this

CREATE  FUNCTION dbo.Initials

(

@STR VARCHAR(4000)

)

RETURNS VARCHAR(4000) AS 

BEGIN

DECLARE

@STR_INIT VARCHAR(4000),

@STR_PROCESS VARCHAR(4000),

@STR_COMPLETE VARCHAR(4000),

@I INT,

@j-2 INT

SET @STR_INIT =LTRIM(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(@STR,'Mrs',''),'Mr',''),'Dr',''),'Rev',''),'Ms',''))

SET @I=DATALENGTH(@STR_INIT)

SET @j-2=0

SET @STR_COMPLETE=''

WHILE @j-2<@I

 BEGIN

  SET @STR_PROCESS= SUBSTRING(@STR_INIT,@J,1)

  IF (ASCII(@STR_PROCESS)>64 AND ASCII(@STR_PROCESS)<92)

  BEGIN

   SET @STR_COMPLETE= @STR_COMPLETE+@STR_PROCESS 

  END

  SET @j-2=@J+1

 END

RETURN (@STR_COMPLETE)

END

----------------------------------------------

If...

Exactly what you are trying to do ?

select distinct a.name from sysobjects a inner join syscolumns b on a.id=b.id and b.iscomputed=1

where a.xtype='U'

The above query will give the table names which contains atlease one computed column

You can try this

create table Numbers (num1 int,num2 int)

insert into Numbers values(1,2)

insert into Numbers values(3,4)

insert into Numbers values(5,6)

declare @temp int

Update Numbers

set @temp=Num1, Num1=Num2, Num2=@temp

try this

t.ColVarchar + ' ' + convert(varchar,t.ColText)

I think there is no need for a function for this, just get the result into @ImageNo using below select statement and use the variable in insert

select

...

I think James needs to know the last modified date of a stored procedure

This can be get from INFORMATION_SCHEMA views in SQL Server 2005

"Date the object was last modified by...

Jeff, you are right.. my method will work for for single characters only

Thanks

You can try this also

select

name,modify_date from sys.objects