In this case you may want to create an OUTPUT parameter to return SCOPE_IDENTITY() thru especially for apps as you can use COmmand Object and return with Execute No Records...

Have you tried running the item that does kill it but watch what is happening during the process with Profiler?

Also, reading the KB articles I don't think SP3 fixes just...

I know of nothing specific on Medical specifications. I did some checking around google and came up nill as well. I do know there are several groups trying to standardize...

Ok, did you restore a full backup and then the first differential wih RECOVER or with NO RECOVER. If RECOVER did you restore the full backup first then the each...

Try this

select * from

 a

left join

 b

on

 a.pk_a = b.fk_a

left join

 c

on

 a.fk_c = c.pk_c OR

 b.fk_c = c.pk_c

where

 a.custid = "xxx"

If your index is set up as unique (which I am assuming it is the primary key and would be) then no it already knows 1 value to find no...

You lost me here:

The column I want to update is ‘ethnicityType’ in families with ‘code’ from RESEARCHethnic. However, families already contains some data which I do not want overwriting/replacing.

You are...

Best answer see here http://msdn.microsoft.com/library/default.asp?url=/library/en-us/optimsql/odp_tun_1_3ws3.asp

If there is a difference it will be insignificant in many cases (especially on an unique indexed field) but large datasets can do the EXISTS situation faster simple because it...

My understanding is they support current version plus one version back (MSDN does not apply this). This is how they handle OSs and most all other items.

Made notes in code.

select

            IsNull([tblApCheckHist].[checknum],0) CheckNumber,

March 24, 2004 at 11:30 am