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 ?
January 17, 2008 3:47 PM
January 29, 2008 1:35 AM