convert a query from access to sql server 2005
Ive recently been given the task of converting an application from an Access database to sql server 2005. One of the queries has this on the ORDER BY Clause
ORDER BY not isdate(Obsolete), not isdate(not_relevant), isdate(assessed), isdate(published), isdate(implemented), not locally_adapted, guidanceType DESC, nice_ref DESC
this wont work on sql server. Locally_adpated is a bit column and I assume you cant order by bit columns. Can anyone give me some pointers for conversion ?
Software/Hardware used:
Software/Hardware used:
ASKED:
January 17, 2008 3:47 PM
UPDATED:
January 29, 2008 1:35 AM
Answer Wiki:
You can order by any column that you wish.
In SQL Server the syntax of ORDER BY is like this.
<pre>SELECT *
FROM Table
ORDER BY Col1 ASC, Col3 DESC</pre>
All data types use the same syntax.
I assume that the ORDER BY would look something like this.
<pre>ORDER BY isdate(Obsolete) DESC, isdate(not_relevant) DESC, isdate(assessed), isdate(published), isdate(implemented), locally_adapted DESC, guidanceType DESC, nice_ref DESC</pre>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
