The mysterious permission issue
As you might have realized, this is not the title of an Agatha Christie book, but rather about some nasty...
2015-01-09
780 reads
Koen Verbeeck
- Twitter: @https://twitter.com/Ko_Ver
- Website: https://sqlkover.com/
- LinkedIn: https://www.linkedin.com/in/kverbeeck/
Better late than never…
Just like last year, I’m a bit late with the obligatory “how was last year and what is this year...
2015-01-08
634 reads
Overview of Published Articles – 2014Q4
Here is an overview of the articles I published in the last quarter of 2014.
INTENSE SCHOOL
MCSE Prep: Overview of T-SQL Windowing...
2015-01-07
526 reads
Formatting Durations in SSAS: Caveat
I recently published an article on MSSQLTips.com titled Format Durations in SQL Server Analysis Services. For those who haven’t read...
2014-12-22
718 reads
Nominated for the 2014 Tribal Awards
Just like last year, SQLServerCentral.com and Simple Talk are hosting the Tribal Awards. In their words:
The Tribal Awards, co-hosted by Simple-Talk and...
2014-12-18
853 reads
PASS BI VC recording is available now
The recording of the webinar I did for the PASS BI virtual chapter is live!
(Quick reminder: it was the same...
2014-12-05
738 reads
Beware the defaults! (in windowing functions) – The Movie!
I was recently contacted by the fine gents of Webucator, an online training services provider. In order to promote their...
2014-11-27
1,076 reads
Nominated for Author of the Year
I have the great pleasure to announce that I have been nominated for the “Author of the Year” award at...
2014-11-20
530 reads
PASS BI VC: How to (not) torment your fellow SSIS developer?
On November 17th 2PM CET I will redo my SQL Server Days presentation How to (not) torment your fellow SSIS...
2014-11-12
701 reads
Overview of Published Articles – 2014Q3
Here is an overview of the articles I published in the third quarter of 2014.
INTENSE SCHOOL
MCSE Prep (SQL) – Using Parameters...
2014-10-24
784 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 KONTAK BCA KCU PONTIANAK Telp,Cs:08218154393
WA:08218154393 Jl. Jenderal Ahmad Yani No.1, Benua Melayu Darat, Kec. Pontianak Sel., Kota Pontianak,...
ALAMAT KONTAK BCA KCU BALIKPAPAN Telp,Cs:08218154393
WA:08218154393 Jl. Jenderal Sudirman No.139, Klandasan Ilir, Kec. Balikpapan Kota, Kota Balikpapan, Kalimantan Timur...
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