Recently I encountered a problem in a stored procedure that was caused by an unexpected result from the SQL Server ISNUMERIC() function. I was using SQL Server 2008 R2 but the issue has long been ...

I realized how much easier my life would be if SQL had a mode() aggregate function. (I'm using it in the mathematical sense). I'm guessing that either I use SQL in a wierd way or there is a good ...