Variables, Nulls and Coalesce

ISNUMERIC() and REPLICATE()

^ : T-SQL

Cast as datetime question

T-SQL

REPLACE Multiple Spaces with One

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.

t-sql first last day date of the month

Returns the First or last day date of the month for a given date.

syscolumns names

get a list of syscolumns names from string comma separated columns list

Generate stored procedure parameter list based on table

Generate stored procedure parameter list based on table, useful when creating new SPs on tables with lots of columns.

Solving the Running Total and Ordinal Rank Problems (Rewritten)

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.