Ok, I'm trying to write a query in a stored procedure in SQL Server 2000. Because some of the parts of the query vary based on certain situations I construct a string that contains the query and ...

Well, I need to get a median value for a set of numbers, from a query. To my surprise, Sql Server does not have a median function/sproc (well, if you install the analysis tools you do, but I can't ...