User Profile

Collapse

Profile Sidebar

Collapse
mmaamoun
mmaamoun
Last Activity: Oct 6 '07, 11:40 PM
Joined: Sep 28 '07
Location: Egypt
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • mmaamoun
    replied to Order By in a View
    in SQL Server
    Excellent, the select top 100 percent ....
    worked like magic for me:)

    Thanks:)...
    See more | Go to post

      Leave a comment:

    • mmaamoun
      started a topic Order By in a View
      in SQL Server

      Order By in a View

      Hi everyone,
      I'm relatively new to MSSQL.
      I was trying to import a view from MS Access to MSSQL that has an order by statement.

      And everytime I tried it gave me the following error:
      "The ORDER BY clause is invalid in views, inline functions, derived tables, and subqueries, unless TOP is also specified."

      ِAnyone can help?

      M.
      See more | Go to post
      No activity results to display
      Show More
      Working...