Generating SubTotals using GROUPING

This article explains how to use the GROUPING clause to generate subtotals for rows in a very easy fashion.

DateTime Puzzle

Find for SQL Objects, Entities or Text

Procedure to find any object such as table/stored procedure by its name, or find for ant text inside stored procedures, functions.

DATETIME Puzzle

Output of Query

Output of Query

What will be output?

Generating charts in SQL Server Reporting Services

This article displays how we can place charts in reports created using SSRS.

Writing Dynamic Stored Procedure

In this article I have shown a way of writing queries in which WHERE clause of the query is executed dynamically depending on values of input parameters.