I think I am OK. Thx. I will pay more attention to execute plan in the future.

When I run this query

 select  distinct [Quiz Name], Score from  [Quiz Log]  INNER JOIN

                      HREMP ON [Quiz Log].[Employee Name] = HREMP.[FULL NAME] AND [Quiz Log].DOB = HREMP.DOB

where   (HREMP.CC = N'010018200')...

Thanks. I was so wrapped for error and update field .

 [DCode] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [PrincipalDiagnosisCode] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

there are the only two fields I need to update.

I never used SHOWPLAN_ALL to analyze my query. Thank...

but in my case, it is the same data type.

after

update InpatientMedStat set  InpatientMedStat.PrincipalDiagnosisCode = ltrim(rtrim(rptpxa2.DCode)) from InpatientMedStat   INNER JOIN   rptpxa2 ON InpatientMedStat.PatientAccountNumber = rptpxa2.PNO  WHERE     (LEN(RTRIM(InpatientMedStat.PrincipalDiagnosis 1 1 0 NULL NULL 1 NULL 6.5258541 NULL NULL NULL 3.6990247 NULL NULL UPDATE 0 NULL

  |--Table Update(OBJECT[Barb].[dbo].[InpatientMedStat]), SET

Sorry. I do not think I understand what you are talking about. Thx.

sorry. here is

CREATE TABLE [dbo].[rptpxa2] (

 [PNO] [nvarchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [AccommondateCharge] [float] NULL ,

 [FClass] [nvarchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [DeathIndicate] [nvarchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [Disposition] [nvarchar] (2)...

Here is the working version. Thx.

CREATE                          PROCEDURE dbo.CCPercent

@quiz VARCHAR( 25 )=null,

@cc   nvarchar(125) = NULL,

@debug     bit          = 0

as

DECLARE @sql        nvarchar(4000)   

begin                                                                  

set @sql='SELECT...

amazed, so easy. Thx.

might be you can use trigger.

It took long time to do any operation in the SQL Enterprise manager.

Btw, my computer 4cpu 1.8 ghz 523.28 kb Ram.

Here is the message after I shrink the database.

I...

just happened . but I am the only use the server. How do improve if the case like yours ? Thx.

it is standard version. I am the only user in the computer. it used to work fine. Last week I imported a lot data into the database. it clogged the...

Yes. but the problem with other database, too. I am defragment the pc right now.