Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

I can't create view having an Order by clause 1

Status
Not open for further replies.

yehong

Programmer
Joined
Sep 22, 2003
Messages
291
Location
US
I am trying to create a view in SQL Server 8.0 but it won't create due to an order by clause in it. If I use TOP 100 it creates the view but the view only pulls 100 records. Is there any workaround to this? Thanks.
 
Thanks. I was forgetting 'percent'.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top