SQL error on order by

[jgurgen]

ORDER BY
Comments.LoanID ASC,
Comments.DateandTime ASC


Server: Msg 1033, Level 15, State 1, Procedure R_reminders_ifs, Line 17
The ORDER BY clause is invalid in views, inline functions, derived tables, and subqueries, unless TOP is also specified.


What is wrong with this Query?

 

[Sheco]

Perhaps the error message is telling the truth?

 

[jgurgen]

it probably is but thats what was genertaed by crystal reports

 

[Sheco]

Did you check into the SQL statement or stored procedure that crystal is trying to use?

 

[jgurgen]

i dont know

 

[Catadmin]

jgurgen,

Sheco can't answer your question because you're only showing us one line of the code. You'll have to post the entire segment for us to be able to answer the question.

If this Order By statement is inclosed in a sub-query, or the Select clause of an Insert Statement, or even an Update statement, then you need remove that one line and you shouldn't have any problem. However, without seeing all the code involved, no one is going to be able to help you out.

Sorry.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"