Comments

Article

In this tip we look at a new feature in SQL Server Reporting Services that allows users to leave comments about reports.

2018-09-21

2,383 reads

Fighting Evil in Your Code: Comments on Comments

by Additional Articles

SimpleTalk

Comments

Article

One of the most glib generalisations you can make about development work is to say that code should be liberally commented, or conversely that it should never be commented. As always, the truth is more complicated. There are many different types of comment and some types are best treated firmly with the delete key, where others are to be cherished and maintained assiduously. Even though it is hard to find two developers who agree on the topic of commenting, Michael Sorens warily sketches out the issues and the battleground.

2017-08-29

3,670 reads

Read the latest Blogs

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

Comments

Adding User Comments to Reports in SQL Server Reporting Services

Fighting Evil in Your Code: Comments on Comments

Blogs

AI Helps Me with My Sloppiness

WITH clause gets a 26ai boost!

Automatic Index Compaction

Forums

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

ALAMAT KONTAK BCA KCP Banjarbaru Telp,Cs:08218154393

ALAMAT KONTAK BCA KCU SAMARINDA Telp,Cs:08218154393

Question of the Day

Getting the Average