T-SQL Tuesday #3: Database Relationships
In my first T-SQL Tuesday submission I thought I'd mention something that we often take for granted when working with...
2010-02-10
457 reads
Blog Posts
Data Types Matter
I was watching Michelle Ufford’s (blog, Twitter) presentation from the 2009 PASS Summit recently on DVD. I had purchased them,...
2010-02-09
968 reads
February OPASS Meeting Tonight
It's here! Our February meeting is tonight at 6pm at End To End Training, 225 S. Westmonte Drive, Suite 2010,...
2010-02-09
377 reads
Interviewed at CSTechCast
The segment should go out in this week’s show, but I spent half a day down in Colorado Springs with...
2010-02-09
360 reads
Isn’t Consulting Risky?
Small Business Ownership. It’s one of the Great American Dreams. Our forefathers, the founders of the country that I call...
2010-02-09
781 reads
I've been published on Simple-Talk.
I am excited to say I have been published on Simple-Talk. This was my first foray into being professionally edited. I...
2010-02-09
325 reads
Join me at the Memphis SQL Server User Group meeting
For almost a year now, I’ve exchanged emails with the leaders of the Memphis SQL Server User Group, trying to...
2010-02-09
324 reads
Pragmatic Works Foundation Class Introduction
You may have noticed a flux of new blog post entires yesterday from a group of people talking about the...
2010-02-09
805 reads
Relationships
This month Rob Farley is hosting TSQL-Tuesday #3. The topic is Relationships and he has left it wide open for...
2010-02-09
881 reads
Relationships - T-SQL Tuesday #3
I missed T-SQL Tuesday #1, but participated in T-SQL Tuesday #2. Now it's time for #3, and I'm making my...
2010-02-09
3,379 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...
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