Sort Feild by 3 criteria 1

[alexanderthegreat]

I want the order by for scrollercategories.id to be 2,3,1

How would I accomplish this?

SELECT TOP 200 dbo.scroller.id, dbo.scroller.srolltitle, dbo.scroller.scrolllink, dbo.scroller.scrollsource, dbo.scroller.eventdate, dbo.scroller.active,dbo.scrollercategories.scrollcategory, dbo.scrollercategories.id AS cid
FROM dbo.scroller INNER JOIN
dbo.scrollercategories ON dbo.scroller.sid = dbo.scrollercategories.id
ORDER BY dbo.scroller.active, dbo.scrollercategories.id, dbo.scroller.eventdate DESC

Thanks

 

[bborissov]

SELECT TOP 200
       dbo.scroller.id, dbo.scroller.srolltitle,
       dbo.scroller.scrolllink, dbo.scroller.scrollsource,
       dbo.scroller.eventdate,dbo.scroller.active,
       dbo.scrollercategories.scrollcategory,
       dbo.scrollercategories.id AS cid,
       CASE dbo.scroller.sid WHEN 2 THEN 1
                             WHEN 3 THEN 2
                             WHEN 1 THEN 3
       ELSE dbo.scroller.sid END AS OrderBy
FROM dbo.scroller
INNER JOIN dbo.scrollercategories 
          ON dbo.scroller.sid = dbo.scrollercategories.id
ORDER BY dbo.scroller.active,
         OrderBy,
         dbo.scroller.eventdate DESC

Borislav Borissov