Or perhaps, given SQL server's new emphasis on "Beyond Relational", in the future it will understand "TOP 100%" to mean that we really do want it to sort the data.

Or...

Not if you write the...

Actually this is extremely easy:

Select * From Information_Schema.Columns

Heh, good question. A good follow-up would be to list what things can NOT be synonyms.

Please see the code that accompanies my powerpoint presentation "The Top 10 Reasons You Aren't Already Using Service Broker" at this location: http://www.movingsql.com/dnn/Portals/4/Materials.zip

It contains an example of most of the...

Yeah, I think that you're right.

But it does have to respect the interior ORDER BY's for local TOP clauses, right? Granted, it can disorder the result set after that...

This is true, but only to the extent that it...

What do you mean "it doesn't work?" If you are getting an error, we cannot see it from here.

Please post the calling and called code.

ritesh.saluja (12/19/2008)

---

Ex. You wrote "In cases where the same activation path must be followed by both". I am unable to understand this.

...

similarly "In cases where the CLR-required activation path can...

Wow, that is an interesting paper. But if most folks have trouble with Celko's Nested Sets, I don't know how I'd ever explain this one to them!

Hmm, you might want to figure out what kind of LOGON this is before you do that then...

Oops, looking at it again, that shouldn't matter if you've already used CAST(..) on the interior select. My guess would be that you are right: it probably is some...

Hmmm, what's your SET TEXTSIZE setting? (use Select @@TEXTSIZE to view it).