View Single Post
  #6 (permalink)  
Old February 12th, 2004, 09:43 AM
joefawcett's Avatar
joefawcett joefawcett is offline
Wrox Author
Points: 9,763, Level: 42
Points: 9,763, Level: 42 Points: 9,763, Level: 42 Points: 9,763, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Exeter, , United Kingdom.
Posts: 3,074
Thanks: 1
Thanked 38 Times in 37 Posts
Default

Perhaps it's trying to be ansi compliant. In theory you can't have an ORDER BY statement on a view unless the view uses the TOP keyword. To get around this it adds TOP 100 PERCENT to the statement.

--

Joe
Reply With Quote