Tina,

I tried Jonathan last code and my code:

SELECT

     event.event_number

   , event.dttm_rcd_added

   , Patients.PatientName

   , Visitors.VisitorName

   , system_table_name

FROM 

 Event 

 JOIN

     (SELECT event_id, Entity.first_name + ' ' + Entity.last_name AS...

can you post the contents of the sp ?

Do you have any triggers set on that table?

You may want to change

@BatchID = @@IDENTITY

for

@BatchID = SCOPE_IDENTITY( )

HTH

Well the short Answer is yes they affect the performance on sort operations, specially if dealing with LARGE tables.

FROM BOL:

In binary collations, comparisons and sorting are based strictly on the bit...

Tina, can you post some sample data?

CCB:

You Can wrap the Above code in an sp:

Like:

CREATE PROCEDURE usp_Users_in_DB (@dbname varchar(128))

AS

Select Count(Distinct loginame) as NoOfUsers

FROM OPENROWSET('SQLOLEDB','Server=(local);trusted_connection=yes','SET FMTONLY OFF exec master..sp_who') AS Q

Where Q.dbName =@dbname

Or if you prefer...

OK, Once more I was RIGHT the answer was WRONG and points are not given

Jeff, thanks for the Correction I have to be a little more careful next time

About DateDiff --- That is not what the poster wanted....

Select Count(Distinct loginame) as NoOfUsers

FROM OPENROWSET('SQLOLEDB','Server=(local);trusted_connection=yes','SET FMTONLY OFF exec master..sp_who') AS Q

Where Q.dbName ='YourDBName'

Due to the results you said then I would change the first Join to LEFT OUTER Like:

SELECT

   event.event_number

 , event.dttm_rcd_added

     , Patients.PatientName

     , Visitors.VisitorName

     , system_table_name

FROM  

 Event 

 LEFT OUTER...

if the ROW on the destination does not exists

then

INSERT INTO Table1 (fld1, fld2,.......,memo)

SELECT Table2.fld1,Table2.fld2, ..., Table2.notes

FROM Table2 left outer join Table1 on Table2.col1=Table1.col1

Where Table1.Col1 is Null

But if the destination exists

Then

Update...

declare @EndDate datetime , @StartDate datetime

Set @StartDate = '2005-08-01 11:30 AM'

Set @EndDate = '2005-08-02 1:30 AM'

select Convert(varchar(5), @startDate - @EndDate, 14) as TimeDiff

Have a look:

http://ambrosoli.com/ambrosoli/how_to_rename_a_sql_server_7_0.htm

That space is usually from the underlying table Field. Have you tried exporting to a file?

can you post the scripts ?