#UNION

Stack multiple tables using UNION ALL

Avoid conversion errors when using UNION to stack rows from multiple tables.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2020-06-19 (first published: 2020-06-16)

3,993 reads

Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...

No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...

A few years ago I took a new job at Microsoft, working as a...

Comments posted to this topic are about the item Let's Talk Certifications, which is...

Title pretty much says it. I want to join to a table that has...

Comments posted to this topic are about the item Building a SQL Server Fleet...

I have this table in a SQL Server 2025 database:

CREATE TABLE [dbo].[CustomerOrder]
(
[OrderID] [int] NULL,
[CustomerID] [int] NULL,
[total] [money] NULL
) ON [PRIMARY]
GO

What is returned from this code? (answers are for the sum and then the count)

SELECT SUM(total) AS sum,
       COUNT(total) AS count
FROM dbo.CustomerOrder;