I need to order my sql query by the number fo times @KEYWORDS is found in the search and then I need to order it by Navigation.name. Do I need to use a CASE statement? I have never used one before ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23285360.html