Summarizing data using GROUP BY and HAVING clauses

You can summarize data to get counts, averages, sums, and more using GROUP BY in T-SQL queries. Greg Larsen shows you how.

T-SQL Comment Best Practices for SQL Server

Learn different ways to add comments to your T-SQL code when working with SQL Server along with several examples.

Which Error

The Ranking Function

Different ways to Convert a SQL INT Value into a String Value

In this article we cover different ways to convert a SQL Server numeric value into a string value.

The July Fourth Anniversary

Working with T-SQL function AVG ()

Learn about the T-SQL function, AVG(), and see how it is used in a few different cases.

The Service Name

Randomizing the Day Inside a Month Using T-SQL

This article shows how you can randomize dates in T-SQL, but keep the month and year the same while the day varies.

The First LEAD