UPDATE T1

SET ACT = T2.ACT

FROM Table T1

INNER JOIN Table T2 ON T1.Action = T2.Action AND T1.Code = T2.Code

WHERE T2.AC = 'AA' AND T1.AC = 'BB'

   AND...

Good for you.

You not allowed to apply bad solutions.

Not in this case.

If to make queries identical:

IF Object_ID('[test_dt]') IS NOT NULL

DROP TABLE [test_dt]

CREATE TABLE [test_dt](

Task nvarchar(50),

date datetime)

INSERT INTO [test_dt]

SELECT...

Select T1.Inspection, T1.Log_Date, T1.Log_Date - MAX(T2.Log_Date) as TimeGap

FROM InspectionRecord T1

LEFT JOIN InspectionRecord T2 ON T1.Inspection = T2.Inspection AND T1.Log_Date > T2.Log_Date

GROUP BY T1.Inspection, T1.Log_Date

What are the datatypes for @CheckForUserID and UserID ?

Are you sure your column UserID contains different values?

You should remove ISNULL's from your function.

If source values not supplied result must be NULL. Now you may just fool yourself and your customers calculating distance to Greenwich meridian when...

Check out sp_executesql in BOL.

Check out topic "triggers, first trigger" in BOL.

If you can explain why you need to restore exactly the same values in timestamp column and what use of it you mean to have we'll probably think about solution...

If you change the schema (set of returned fields is a part of schema) you need to change the code.

But it must not be manual.

If you have a table with...

Just to simplify Ryan's solution:

ALTER TABLE Claims

ADD CONSTRAINT CKTbl_Claims_DateClosed

CHECK (ClaimStatusID <> 2 OR DateClosed IS NOT NULL)

UPDATE A

SET name = ISNULL(BN.value, A.name), 

      email = ISNULL(be.Value, A.email),

      age = ISNUL(BA.value, A.age)

FROM tblA A

LEFT JOIN tblB BN ON BN.id = A.id and BN.columnname = 'name'

LEFT JOIN tblB BE...

I believe if you create indexes on both H.DialID and D.DialID run time must fall under 1 second.

Not to mention an index on D.ProjectID, of course.

Select Identity(int, 1,1) as ID, A, B,C

INTO #Table

FROM TheTable

ORDER BY A, B, C

Select T.A, T.B, T.C, COUNT(DT.ID) as Seq

FROM #Table T

INNER JOIN #Table DT ON T.A = DT.A AND T.ID...

SELECT CreationDate , Amount

FROM Test WITH(NOLOCK)

WHERE CreationDate >= '2006/07/01'

AND CAST(NULLIF(Amount, '') AS FLOAT) <= '10000'