I would say "none"...

I don't see anything that can't be done with a set-based solution, which performs much better. I suggest you to try to convert this into a set...

Of course they can! How do you think Italy won the last World Cup?

Ok, so this could do the trick:

DECLARE @selectedId TABLE (id int)

INSERT INTO @selectedId

SELECT id,

FROM feed

where manager= 'smith'

ORDER BY NEWID()

UPDATE feed

SET selected = 1

FROM feed AS F

INNER JOIN @selectedId AS...

I would suggest you to save the id of the selected rows in a temp table and then update in join with it.

It depends if the update happens in the...

It's not you to decide, it's the query optimizer. Personally I never join on columns that are not to be joined and I keep filters in the WHERE clause. This...

WayneS (6/24/2009)

Gianluca Sartori (6/23/2009)

LOL! What's your hourly fee, Wayne? I need to get the grass...

And there is the third

http://www.sqlservercentral.com/Forums/FindPost741056.aspx

and fourth

http://www.sqlservercentral.com/Forums/FindPost741074.aspx

Maybe the same person? Did you...

Check this:

http://www.sqlservercentral.com/Forums/Topic740368-146-1.aspx

Check this:

http://www.sqlservercentral.com/Forums/Topic740368-146-1.aspx

Oh, I see. Thanks to Wikipedia I found out who he was.

He died when I was 7, that's why I don't know him...

Glad you found a solution.

I'm sorry, but I don't know Tommy Cooper. He doesn't seem to be very popular here in Italy...:-)

Ciao

Gianluca

You can use in the case expression any numbers you like, they just define the order you want to assign to the row in one case (my condition is met...

First of all, the jokes in your signature almost made me run away from this thread... They really are horrible!:hehe:

Your code is really long and complex, although I must admit...

You always need to order by the case expression first. Ordering by a constant integer value means ordering by the Nth column of the results. In your example, order by...

In remote linked servers there's a query timeout that can be set in the "Server Options" tab.

The main issue is that the query doesn't return results in a reasonable time,...