Presenting at 2010 European PASS – Sort Of
I was so looking forward to the trip to Germany to speak at the European PASS Summit
on April 22nd. Two...
2010-04-23
424 reads
pturley
Report Recipe Book Released
Our SQL Server Reporting Services Recipe book was released in April. This is
a cookbook style book for experienced SSRS designers...
2010-03-21
548 reads
Dynamically Adding and Removing Columns to a Query and Report
Creating one report to meet multiple business requirements can save a lot of work
down the road. A common scenario is...
2010-03-16
824 reads
How to parameterize a TOP values query
There are certain key words in a T-SQL query than cannot be parameterized, including
the TOP statement. Consider the followong attempt...
2010-03-16
813 reads
Return the Value of a Specified Dataset Row Outside a Data Region
I want to return the field value for a specific row to a textbox below a table in
my report. To...
2010-03-16
451 reads
User is prompted to login when viewing a report
A user has been added to a SSRS role for the report folder or report but is still
prompted to login....
2010-03-16
1,917 reads
SPB Applications for Windows Mobile
<<placeholder>>
…for product review
Weblog by Paul Turley and SQL Server BI Blog.
2010-03-12
420 reads
Alternate Row Colors in an SSRS 2000 or 2005 Matrix
To create a "greenbar" report in a table with alternating row colors, you can simply
use the RowNumber function to determine...
2010-03-11
1,696 reads
Column Chart with Goal Threshold Line
Chart reports are an effective way to visualize data to show trends and comparisons
in a way that can help the...
2010-03-11
2,030 reads
Creating a Business Scorecard
Report Recipes
This is the second in a series of three articles highlighting the Report Solution
Patterns and Recipes from Chapter 7...
2010-03-11
924 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
The Empty Aggregate
Comments posted to this topic are about the item The Empty Aggregate
Question of the Day
The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers