I want to set up a stored procedure where the data is ordered by column according to user input, i.e.GetSomeData(@SearchPhrase varchar(80), @SortCode int) ASSELECT Field1, Field2, Field3 FROM tbl ...

Is it possible to order by a substring in a returned field?I've got a query which returns at most probably around 10 or so rows of 1 column. However the way this data is formated, it'd be convient ...

SQL Server 2016 introduces substantial new capabilities that promise to advance organizations to manage data for business intelligence and analytics.

Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation.