Introduction to SQL Server 2012 – Webcast Resources
First, I would like to thank everyone for joining my webcasts today. Very much appreciated. Secondly, I would like to...
2013-04-12
1,039 reads
Patrick LeBlanc
SQL Lunch – Power View Against Multidimensional Models
It has been some time since I have hosted or presented on the SQL Lunch. Work and home life is...
2013-03-19
1,325 reads
Successful BI for Educational Institutions
Do you work for US Education? Are you interested in Learning about Microsoft BI? If so, please join me as...
2013-03-15
1,271 reads
SSRS – Using a List Item to Display Details
How many times have you been asked to develop a report that displays the details for a specified group? For...
2013-03-11
3,074 reads
SSRS 101 – Creating a Shared Dataset
Now that you have created a Share Data Source, it’s time to add some data to your project. In this...
2013-02-26
2,886 reads
SSRS 101 – Creating a SQL Server Reporting Services Project
This is the second installment in this series of SQL Server Reporting Services 2012 Beginner posts. You can read the...
2013-02-07 (first published: 2013-01-29)
4,851 reads
SSRS 101 – Prerequisites
Before I actually start explaining and demonstrating how to build SQL Server Reporting Service (SSRS) reports there are few things...
2013-02-01 (first published: 2013-01-23)
4,270 reads
SSRS 101 – Creating a Shared Data Source
In continuation with my previous post on Creating a SQL Server Reporting Services (SSRS) Project, you will now learn how...
2013-01-31
2,568 reads
SQL Server 2012 for Beginners
I have been working for Microsoft for the past two years. One of the most enjoyable parts of my job...
2013-01-22
984 reads
Power View Matrix Drill Capabilities
The features and capabilities of Power View have definitely improved since its release. One of my favorite features is the...
2013-01-21
3,733 reads
Blogs
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
The Goldilocks problem – Materialized Views
I’m sure you’ve all heard the tale of Goldilocks and the Three Bears, but...
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
How We Handled a Vendor Retry That Loaded Twice in Snowflake
Comments posted to this topic are about the item How We Handled a Vendor...
Cognitive Coverage
Comments posted to this topic are about the item Cognitive Coverage
Question of the Day
Getting the Average
I have this data in the dbo.Commission table in a SQL Server 2022 database.
salesperson commission Brian 12 Brian 16 Andy 7 Andy 14 Andy 21 Steve 20 Steve NULLAll the data is a varchar, and I decide to run this query to get the totals for each salesperson.
SELECT SalesPerson
, AVG(TRY_PARSE(Commission AS int)) AS TotalCommission
FROM commission
GROUP BY SalesPerson
GO
What average commission is calculated for Steve? See possible answers