ORDER BY in stored procedures

[gojohnnygogogogo]

hello,
I am trying to order by in my sp, but I can't.
I am doing this :

SELECT * FROM table
ORDER BY INSERTDATE DESC
UNION
SELECT * FROM table

and I get the erorr :
incorrect syntax near the keyword UNION.

anybody seen this before ?

 

[rt63]

Order by should come after all the union queries have been defined. It applies to the complete result set after union and not to individual result sets, hence the error. The code should be something like

SELECT * FROM table
UNION
SELECT * FROM table
ORDER BY INSERTDATE DESC
RT