Get concatenated value for a column without cursor

This script provides comma separated values of one column for each value of another column. It provides it in SQL 2005 without using cursor.

SELECT INTO

How many Records Will Get Selected

HAVING

Quoted Identifier

set ansi_nulls

Finding Ratio between two numbers

This function finds the ratio betwen two numbers.Just plug into your SP and enjoy.

Sins of SQL: The Time Table

Steve Gray discusses one of the oldest OLAP techiques for representing the time dimension - and shows why it's a lot easier to stick to DATETIME values.

SQL syntax

Sending HTML Newsletters in a Batch Using SQL Server

Sending a large volume of emails can put a strain on a mail relay server. However many people using SQL Server will need to do just that for things like newsletters, mailing lists, etc. Satnam Singh brings us a way to spread out the load by sending newsletters in multiple batches instead of one large process.