Create table scripts (
   UserID int,
   UserName char(50),
   ScrRan   char(50),
   StartTime datetime default getdate(),
   EndTime   datetime);

Create table errors (
   ID int,
   UserName char(50),
   UserLogin char(50),
   ErrorNumber int,
   Message char(100),
   TimeOfError   datetime default getdate());

declare @error int 
declare @msg varchar(100) 
declare @startTime datetime 
declare @endTime datetime

select @startTime = getDate()

SELECT *
INTO #Temp
FROM Publisher
WHERE pub_Name = 'Scene Publishing'

UPDATE #Temp
SET pub_Name = UPPER(pub_Name)


SELECT *
INTO Publisher
FROM #Temp

 
--Begins Error Checking Routine 
select @error = @@error 
  
IF @error <> 0 
  BEGIN 
     select @msg ='error: ' + convert(varchar(7), @error)      + 
                '' 
     insert into errors values (@@SPID, USER, USER_NAME(), @error, 
                                @msg, getDate()) 
  END 
ELSE 
  BEGIN 
    select @endTime = getDate()

    insert into scripts values (@@SPID, SYSTEM_USER,                             @startTime, @endTime) 
  END 
select * from errors 
select * from scripts

quote:

---

Originally posted by DonAtWork

Why not simply UPDATE your table?

UPDATE Publisher SET pub_Name = UPPER(pub_Name) WHERE pub_Name = 'Scene Publishing'


[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

---