Hello, Grant again as Steve is on sabbatical. My evenings and weekends are currently being used to update my SQL Server query performance book for 2025. I really enjoy it because writing the book forces me to structure my learning on SQL Server 2025, not just hit it in some slipshod manner. Plus, I've got […]
2025-07-04
96 reads
Hey all! It's me, Grant. For those who don't me, Grant Fritchey. I work with Steve Jones, the person normally talking to you here. Yes, Redgate actually employs me, and continues to. I don't know why either. Anyway, Steve is off for a few weeks on his sabbatical. More power to him and I hope […]
2025-07-02
116 reads
Joe Fleming wants to know how I solve weird problems. I’m not sure I’m actually qualified to answer this question since I, myself, am a weird problem, but I’ll...
2025-06-30 (first published: 2025-06-10)
344 reads
I have a proper blog post coming out tomorrow for T-SQL Tuesday, but today, celebrate with me that SSMS 21 finally, at long last, fixes the irritating fact that...
2025-06-23 (first published: 2025-06-09)
1,032 reads
Before I start the whining (whinging if you prefer), let me just say I have the greatest job in the world. I'm exceedingly lucky to have it. I'm grateful as can be. And someone else (looking at you Tim) can get it when they pry it from my dead cold fingers. With that out of […]
2025-06-16 (first published: 2025-05-31)
164 reads
I’m working on an update to my Query Performance Tuning book for SQL Server 2025 and I found myself wondering, will a query hint be immediately apparent in an...
2025-06-11 (first published: 2025-05-26)
496 reads
I won’t try to pretend otherwise, I’ve had some mixed feelings about Stack Overflow for a long time. I think the concept of the place, ask a question, get...
2025-06-04 (first published: 2025-05-21)
418 reads
I recently was privileged to speak at SQLDay in Wroclaw Poland… man, I love visiting Poland… Anyway… Great event. Worth your time to attend, and if you’re a speaker,...
2025-05-22
46 reads
You know I had to do it as soon as I found it was possible. Yes, I installed and enabled AI in the DBeaver Query Editor so I can...
2025-05-21 (first published: 2025-05-05)
261 reads
Just a quick one this morning. I’m on the road and haven’t worked up a full blog post, apologies. I’ve been using the preview for SQL Server Management Studio...
2025-05-12
209 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...
WhatsApp:0817839777 Jl. Kisamaun No.57, RT.001/RW.006, Sukasari, Kec. Tangerang, Kota Tangerang, Banten 15118
WhatsApp:0817839777 Jl. Ciledug No.162, Kota Kulon, Kec. Garut Kota, Kabupaten Garut, Jawa Barat 44112
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