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.

case statement puzzle

What will this return?

Securing Reporting Services Reports

Learn how you can get the userid of someone connected to Reporting Services and use that information to determine if they can view the report.

Careful with table name alias

Another way to get a table list from a string

I prepared this version (my original did not used XML)
By being helped by forums feedback from SQL central
Forward it to yours peers.