Order by active where active is 1first then where active is 0 1

[alexanderthegreat]

I want to sort the result of this view, so that it sorts by eventdate first descending and where active = 1 then where active = 0 to follow

SELECT TOP 20 dbo.homepage.id, dbo.homepage.title, dbo.homepage.shortdescription, dbo.homepage.active, dbo.homepage.eventdate, dbo.homepage.image,
dbo.homepage.imagecaption, dbo.homecategories.id AS cid, dbo.homecategories.homecategories
FROM dbo.homecategories INNER JOIN
dbo.homepage ON dbo.homecategories.id = dbo.homepage.cid
WHERE (dbo.homecategories.id = 1)
ORDER BY dbo.homepage.eventdate DESC

 

[SQLDenis]

order by eventdate DESC,active desc

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[vongrunt]

Bonus question: how to sort desc where active=1 then asc where active=0?

------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]