Try this:
ORDER BY 1, 2
OR
ORDER BY rsc.RadioServiceCodeId, rsc.RadioServiceCode + ' - ' + rsc.RadioService
More Related Contents:
- Is it possible to write single query on two table which are not connected to each other?
- How to create a specific SQL Server stored procedure? [closed]
- SQL Server dynamic PIVOT query?
- SQL Server – Best way to get identity of inserted row?
- Should I use != or for not equal in T-SQL?
- How to update two tables in one statement in SQL Server 2005?
- SQL Server Process Queue Race Condition
- Create a date from day month and year with T-SQL
- How should I pass a table name into a stored proc?
- Is the NOLOCK (Sql Server hint) bad practice?
- Creating an index on a table variable
- SQL – Subtracting a depleting value from rows
- Parse comma-separated string to make IN List of strings in the Where clause
- How to set variable from a SQL query?
- SELECT FOR UPDATE with SQL Server
- Compare DATETIME and DATE ignoring time portion
- T-SQL: Selecting Column Based on MAX(Other Column)
- How to group by month from Date field using sql
- unresolved reference to object [INFORMATION_SCHEMA].[TABLES]
- T-SQL How to create tables dynamically in stored procedures?
- What is the equivalent of ‘describe table’ in SQL Server?
- Curly braces in T-SQL
- OPENXML with xmlns:dt
- Find min and max for subsets of consecutive rows – gaps and islands
- Update query using Subquery in Sql Server
- When using GETDATE() in many places, is it better to use a variable?
- How do I compare 2 rows from the same table (SQL Server)?
- COALESCE Function in TSQL
- Convert bigint to datetime
- When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?