My guess,

you have a table with nullable columns that you use with a unique index.

A primary key constraint cannot be defined on nullable columns.

With a unique index, you can...

should be single quotes ..

SELECT @TestSql = 'INSERT INTO @TestTable SELECT au_id,au_fname From [pubs].[dbo].[authors] '

EXECUTE (@TestSql)

Is this what you're looking for ?

select J.Name as JobName, RP.program_name

 from msdb..sysjobs J with (nolock)

  inner join  master..sysprocesses RP with (nolock)

      on RP.program_name like 'SQLAgent - TSQL JobStep (Job '...

I hope your day today will be mutch better

Regarding the hyperlink : Believe me, once you seen Sheryl explain the whole stuff, you'll...

No, this only means that a litle testing is advisable for anyone who wants to build some knowlage of an rdbms. It's not because any solution works "optimal" for me,...

I thought the smilies would give enough indication that that reply was only ment to be a litle dry humor. After all there was no sql-technical info involved

As always, you'll have to compare execution plans and runtimes to build your choice on. Hey, this may even by the occasion for a 'aha-erlebnis'

Hey, I thought the were bits and pieces of bricks and cement with your last reply

As far as I'm concerned you may as well...

Perform it on both, maybe that gets it all into the daylight, but at least perform it where you are having the problem (i.e. the select).

- QA\Query\display estimated execution plan...

read my previous reply

Activate the "show (estimated) execution plan" in QueryAnalyser, maybe that will clarify the issue.

Do you have an index on column Code ?

If not it will have to perform a table-scan and therefor it will not be able to read through the uncommitted row(s).

If the relation between the temp-tb and the tb is 1-1 and you're checking existance on the unique key, supporting it with a clustered index might speed up this join-operation.

With...

And that are just the adjustments you need to rename the tables.

(You coud script your db and perform the rename textwize and recreate it...

you could also use tools like CA-ERwin,...

In addition to Ray's addition   :

Having more Deadlocks lately ?

I guess that should be a right join because the exists-function is done using the  tblMMStudentTestScores.

But because I prefer using Left joins (I find it smoothly to read) ...

SELECT ...

FROM #tblMMStudentTestScoresTEMP...