Hashing

How to get monthly YTD data

This article presents an easy method to get YTD data grouped by months in T-SQL.

Multiple Inserts

Time Zone

T-SQL Development, or: How I Learned to Stop Worrying and Love Word

Microsoft Office Word is useful. There, I have confessed it, it's useful to me while I am working with TSQL. It's possibly only the search and replace function that I like but it's wrapped in Word so I have to take it like that. I use it a lot to help me capture the results of a stored procedure.

Numbers

Pros and cons of six SQL table tools

This article shows how to use 6 SQL table-based tools to solve the same problem, and gives the pros and cons of each.

Triggers

Building Ranges using T-SQL

We often use excel for any running repetitive calculations since it is a very convenient user friendly interface which allows us to just enter a formula in a cell and simply drag and drop the formulas to generate a complete output.

Using SP_