Advanced Querying

SQLServerCentral Article

Working with Time Frames in T-SQL

  • Article

There is often a need to work with time data representing various events and then reporting on them in SQL Server applications. However T-SQL doesn't necessarily make this easy. However new author Joe Lynds brings us an article on some advanced T-SQL to do just that.

You rated this post out of 5. Change rating


11,886 reads

External Article

How to Use GROUP BY in SQL Server

  • Article

Summarizing data in a SELECT statement using a GROUP BY clause is a very common area of difficulty for beginning SQL programmers. In Part I of this two part series, we'll use a simple schema and a typical report request to cover the effect of JOINS on grouping and aggregate calculations, and how to use COUNT(Distinct) to overcome this.


5,253 reads

External Article

SQLChess - A tutorial on thinking in sets

  • Article

Chess makes a fantastic game for programming examples. You will find hundreds of examples on the internet. Some dedicated to OO patterns, others to algorithms and so forth. Unfortunately, most of these examples do not use a database or if they do, treat the database as nothing more than a storage repository. In this series of articles we will use SQL Server and T-SQL to implement the game of chess with an emphasis on thinking in sets.


5,228 reads


Friday Flyway Tips–Comparison Options


Recently a customer asked how they could get index changes to be captured in...

A New Word: Guiltwrights


giltwrights  – n. the imaginary committee of elders that keeps a running log of...

Becoming Kristyna Ferris <3


Hey folks, fun personal post today. A few weeks ago, I got married! My...

Read the latest Blogs



By Louis Davidson (@drsql)

Comments posted to this topic are about the item Love

Drop or delete a existing partition

By Siten0308

Hello, so I was reading on partitioning a large table, Which i successfully did,...

PostgreSQL authenticated against Microsoft Active Directory


Can I authenticate with Active Directory and get into PostgreSQL? Version: PostgreSQL 16.1 on...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers