I’ve started up a monthly Bullet Journal workshop: a recurring meetup to talk organization, productivity, and tools to support mental health. All centered around Bullet Journals, of course. The...
2021-04-06
7 reads
I’ve started up a monthly Bullet Journal workshop: a recurring meetup to talk organization, productivity, and tools to support mental health. All centered around Bullet Journals, of course. The...
2021-04-06
9 reads
Control Flow activities in Data Factory involve orchestration of pipeline activities including chaining activities in a sequence, branching, defining parameters at the pipeline level, and passing arguments while invoking...
2021-04-06 (first published: 2021-03-25)
205 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-04-06
18 reads
SQL Server offers a lot of flexibility when working with objects like stored procedures and temporary tables. One of the capabilities is to allow for stored procedures to call...
2021-04-06 (first published: 2021-03-26)
952 reads
I recently encountered a SSIS package that was failing due to an ‘arithmetic overflow error converting IDENTITY to datatype int’; Conversion/overflow errors aren’t that unusual – normally a data...
2021-04-06
65 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-04-05
23 reads
This is part four in a five part series this week, Moving into Consulting 101.
Today's topics give you a numerical advantage in consulting. All have a common theme: don't wing...
2021-04-05 (first published: 2021-03-25)
272 reads
Let’s take a look at the final few steps of your initial server intake process and get your workflow up and running as you push toward performing regular server...
2021-04-05 (first published: 2021-03-25)
315 reads
This came up because a user had db_owner perms and it was only reading from a database and creating a table variable from it. I created a new user...
2021-04-05
15 reads
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
By way of background, a while back I did video called “My New Favourite...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Comments posted to this topic are about the item How We Handled a Vendor...
Comments posted to this topic are about the item Cognitive Coverage
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