Soft Skills

External Article

Developer-Tester Relationships

  • Article

In a development team, there are times when the relationships between developers and testers can become strained. How can you turn this potential conflict into something more positive? Is it part of the skill of team-working to find ways of avoiding friction, or should one blame a system that relies on good social skills to work well?

2015-05-22

11,013 reads

Blogs

Automatic Index Compaction

By

Index maintenance has always meant nightly jobs and a window you have to defend....

The Goldilocks problem – Materialized Views

By

I’m sure you’ve all heard the tale of Goldilocks and the Three Bears, but...

Monday Monitor Tips: Virtual Machine Usage and Cost

By

One of the things I’ve been requesting for a number of years is cost...

Read the latest Blogs

Forums

SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About

By Terry Jago

Comments posted to this topic are about the item SQL Art, Part 4: Happy...

Alamat Kontak Resmi BCA KCP Sungkono ??/Cs 083178278662

By Layanan.24.jam

WA:083178278662 Darmo Park, Komp, Jl. Mayjen Sungkono I No.4-6, Darmo, Kec. Wonokromo, Surabaya, Jawa...

Alamat Kontak Resmi BCA KCP Biliton ??/Cs 083178278662

By Layanan.bca

WA:083178278662 Jl. Kalimantan No.14, Gubeng, Kec. Gubeng, Surabaya, Jawa Timur 60281

Visit the forum

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       NULL
All 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