Generating SubTotals using GROUPING
This article explains how to use the GROUPING clause to generate subtotals for rows in a very easy fashion.
2012-11-16 (first published: 2010-07-13)
38,100 reads
Sunil Chandurkar
2012-05-07
2,549 reads
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.
2012-04-18 (first published: 2008-05-28)
2,987 reads
2011-11-17
2,508 reads
2011-10-10
2,768 reads
2010-10-28
3,121 reads
2010-03-25
4,406 reads
Generating charts in SQL Server Reporting Services
This article displays how we can place charts in reports created using SSRS.
2010-02-01
12,826 reads
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.
2009-06-01
19,356 reads
Blogs
AI: Blog a Day – Day 7: Vector and Vector Databases
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
Forums
Why End-User Testing Is Even More Important with AI
Comments posted to this topic are about the item Why End-User Testing Is Even...
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers