Another in our series of articles to help you fill in the cracks in your knowledge with SQL Spackle. MVP Jeff Moden shows us how IsNumeric works and how you should use it.
2012-09-14 (first published: 2010-12-01)
Replacing multiple spaces with a single space is an old problem that people use loops, functions, and/or Tally tables for. Here's a set based method from MVP Jeff Moden.
2012-08-17 (first published: 2009-11-16)
Revisiting his very popular article on the running total and ordinal rank problems, MVP Jeff Moden brings us a detailed analysis of how you might want to implement a solution in T-SQL.
2012-01-27 (first published: 2009-11-10)
This creates a Tally or Numbers table which is frequently used to replace loops in code and is much faster than most loops.
2011-11-24 (first published: 2008-03-07)
An "old" subject is revisted where "newbies" can learn the methods and veteran users can get more performance out of the code.
2010-08-06 (first published: 2008-08-19)