> --------------------
> SELECT @TempID = NewsID FROM News WHERE Category = 0
> ORDER 
> BY PublishDate DESC
> --------------------

Now it makes sense! when I set a variable using SELECT on an entire 
recordset, not a single record, I end up with the value of the last record.
Whereas when I query from say ASP the cursor is sitting right on the first 
record.

Thanks!