Categories / t-sql
Transposing Rows into Columns Based on a Range in T-SQL
How to Retrieve Up-to-Date Non-Null Values from Columns with Missing Data Using COALESCE Functions.
How to Create SSRS Reports with Different Aggregation Algorithms on the Same Column
Using Window Functions to Select and Modify Rows in a Table
Understanding GUIDs and Identity Functions in SQL Server: Choosing the Right Tool for Unique Instance Identification
Calculating a 30-Day Moving Average on Transaction Dates in SQL Server Using GETDATE() Function