Diogo Castro

Representing XML data in SQL Server

In this article, we will see how to use the FOR XML statement in SQL Server to represent the result of queries in XML format.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(21)

You rated this post out of 5. Change rating

2020-04-24 (first published: 2018-08-07)

6,705 reads

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

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

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

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

WA:08218154393 Jl. Kertajaya No.35, Airlangga, Kec. Gubeng, Surabaya, Jawa Timur 60281

Comments posted to this topic are about the item How We Handled a Vendor...

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?