The Way - The Reason
This is one thing outside the SQL World, but it has very strong place in every aspects, it is one...
2010-04-02
615 reads
Blog Posts
The Web 3.0 has finally arrived… It’s The Cloud
The 2008 trending topic everyone was talking about was the Web 2.0. On October 23 that same year, Amazon EC2 dropped the Beta label and the story accelerated: Less...
2010-04-02
19 reads
The Web 3.0 has finally arrived… It’s The Cloud
The 2008 trending topic everyone was talking about was the Web 2.0. On October 23 that same year,...
2010-04-02
17 reads
What happens when Windows is the step-child? Adventures in Ruby on Rails.
Like many of you I’ve heard the developer community going on about Rails for quite a while now. It wasn’t...
2010-04-02
1,464 reads
Winner of the March SQL Aloha Contest
The March SQL Aloha contest had a total of 25 entries, and all of them were great responses to this...
2010-04-02
422 reads
A DMV a Day – Day 1
Just as an experiment, I am going to post a different DMV query every day for the next 30 days. ...
2010-04-01
896 reads
Announcing Quantum Compare v1.01
I bet most of you use some type of diff/comparison tool at work. Probably one for the file system and...
2010-04-01
541 reads
April Fools is Fun
Some good jokes going around, and the few I wrote for SQLServerCentral went over well. There was a good one...
2010-04-01
562 reads
April Question: What advice would you offer a novice DBA in order to help them along in their career?
Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if...
2010-04-01
484 reads
Blog Topics - Where do you draw the Line?
I started blogging a few months ago and since I started writing my own blog, I've been a much bigger...
2010-04-01
499 reads
Blogs
AI Helps Me with My Sloppiness
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
WITH clause gets a 26ai boost!
By way of background, a while back I did video called “My New Favourite...
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
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...
Alamat kantor BCA KCU DIPONEGORO Telp:(0817)866887
WA:0817-866-887 Jl. Dr. Soetomo No.118, Darmo, Kec. Wonokromo, Surabaya, Jawa Timur 60241
Alamat kantor BCA KCP Kusumabangsa Telp:(0817)866887
WA:0817-866-887 Jl. Kusuma Bangsa No.35, Ketabang, Kec. Genteng, Surabaya, Jawa Timur 60272
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