Thanks for the feedback, Tracey. Except for the SPID (I had an active connection with 58), that's the exact code I used. Got zero rows in return no...

Compare that to where C/C++ programmers have been for over 15 years: they can write new code targeted to run on multiple different platforms right from the start AND expect...

bitbucket (3/7/2008)

---

I owe this to a person or persons unknown but it worked for me.

Run sp_who or sp_who2 to obtain the process id (spid) then

DECLARE @Handle binary(20)

SELECT @Handle...

Thanks, Barry... Which state is Drexel in and which major is this typically for?

I'd still like to know which school Kaiitong is going to...

Thanks Adam, but he said

I want to know how many rows are in the destination table. That will answer...

Cool! Which school?

How many rows in the desitination table?

Dang, Barry... good stuff but awfully long for saying that folks preach the standards right up to the point where the standards don't work for them and then they violate...

Barry, you're correct... the single column update example yields nearly identical results for both query types in 2k5.

[font="Courier New"]Correlated Subquery...

Table 'TargetTable'. Scan count 1, logical reads 54, physical reads 0,...

Thanks for that...

Oh... ok. Thanks Jack.

Hey, do you have a dates table? I've got a neat trick to show you if you do...

Like this...

--===== Solve the problem is 2k5

SELECT Category,[Desc],ID,

DENSE_RANK() OVER (ORDER BY Category,[Desc]) AS Seq

FROM #yourtable

ORDER BY...

You really...

Sure... use DENSE_RANK instead of ROW_NUMBER... look it up in Books Online... except for the partition, the rest of the query will be pretty much the same...

Ummm... just in case you don't have a "Dates" table like what Jack used, please consider the information at the following URL...

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html