Yep, definitely backwards. Good catch.

Must ... drink ... more ... caffeine.

>>we can select just any one row.

So it's arbitrary then ?

If so, just locate 1 other data element that uniquely identifies the row to act as a tie-breaker. Looks...

 ^{-- return the total number of products using an OUTPUT variable}

^{SELECT @HowManyProducts = COUNT(ProductID) FROM Products}

^{Shouldn't you be returning the...}

>>doesn't SELECT...INTO lock the database

Database lock ?

Creation of a table requires locks on the system tables that contain the table/column definitions. Pages in tempdb's sysobjects and syscolumns may be...

What is the data source ? SQL or non-SQL ?

Instead of a long-running row-by-row DTS process, you can minimize Insert/Update duration and duration of locks by pulling the data into...

Join to a derived table that aggregates the required MAX() data:

Select t.Item, t.Locn, t.Sales, t.[#Months], dt.MaxMonths

From YourTable As t

Inner Join

(

  Select Item, Max( [#Months] ) As MaxMonths

  Group By Item

) dt

 ...

Remi's solution and diagnosis was dead on. Please re-read it.

>>i guess that is not the solution because see when i do the insert in the table Transactioncountss it is...

Create a linked server and perform the operation as 1 set-based UPDATE. Assuming you've named the link "DB":

UPDATE orcl

SET

  EMP_SK = sq.emp_sk

-- Use linked server. Careful - Oracle names are...

In addition to re-thinking, it can't hurt to learn the correct syntax for assigning multiple variables at once, using SELECT and not SET:

Instead of:

set @var1 = (select mytable.field1 from mytable...

The issues are:

- performance

- locale safety

Testing over large data volumes will show that SELECT DATEADD(dd, DATEDIFF(dd,0,@mydate), 0) is the fastest way to strip off time.

Use of string converts can lead...

Creating a temp table inside a proc causing a recompile ?

Cardinality ? Is DocPhrase in a 1 to 1 relationship with the table you're deleting from ? If not, JOIN...

>>why did he design the code that way

I usually see this alternative time stripping method coded using Floor() rather than cast as int. I expect it was a lack of...

This explains the "why" of what you're seeing:

http://vyaskn.tripod.com/searching_date_time_values.htm

>>3. Delete entries in RespondentLOV that do not exist in Respondent

That wasn't the requirement. Hence the complexity. RespondentLOV records were not to be deleted, they were to be remapped to...

Select @GUID = NewID()